How To Add Date Column In Power Bi

by

In Power BI, you can add a date column by following these steps:

  1. Open your Power BI report or create a new one.
  2. Go to the “Modeling” tab in the Power BI ribbon.
  3. Click on the “New Column” button in the “Calculations” group.
  4. In the formula bar that appears, enter a name for your new date column and the desired formula. Here are some examples of commonly used date formulas:
    • TODAY(): Returns the current date.
    • NOW(): Returns the current date and time.
    • DATE(year, month, day): Returns the specified date.
    • DATEADD(startDate, numberOfIntervals, interval): Returns a new date after adding the specified number of intervals.
    • EDATE(startDate, numberOfMonths): Returns a new date after adding or subtracting the specified number of months.
    • EOMONTH(date, numberOfMonths): Returns the last day of the month after adding or subtracting the specified number of months.
  5. Press Enter to create the new date column.
  6. Your new date column will now appear in the fields pane on the right side of the Power BI report.
  7. You can use your new date column in visualizations, filters, and calculations within Power BI.

For example, if you want to create a date column that shows the current date, you can enter the following formula in the formula bar:

    TodaysDate = TODAY()

Leave a comment