POWER BI: Modeling

Time Intelligence Functions

FIRSTDATE function

Returns the first date in the given context.

Formulas:

                   FirstDate_Sales = CALCULATE(SUM(TransactionData[Revenue]),
                                     FIRSTDATE(CalenderDate[Date]))
	            

                   FirstDate_NonBlank = CALCULATE(SUM(TransactionData[Revenue]),
                                        FIRSTNONBLANK(CalenderDate[Date],SUM(TransactionData[Revenue])))
	            

                   FirstDate_Calendar = FIRSTDATE(CalenderDate[Date])
	            

Power BI Demo:

How to Make:

• In Power BI Desktop create a new measure using the formulas above.
• Under visualizations select table
• Select or Add in the date column (i.e CalenderDate[Date]) from the calendar date table.
• Select or Add in the new measures to the values section

Additional Comments:

Shows how FIRSTDATE functions works in different contexts.