Using the FIRSTDATE function

This function returns the first date in the data column that you pass as an argument. You can use the FIRSTDATE function to find the first occurrence of a transaction or the first time an accident was reported that was associated to blowing sand.

How to do it...

1. Open the Model.bim to the Calc_Date_T table.

2. In the measure creation area, click on an empty cell to create a measure to return the first date found on the Calc_Date_T table:

           First_Accident:=FIRSTDATE(Calc_Date_T[CRASH_DATE]) 
   

   

3. A more interesting date will be finding the first occurrence of an accident logged due to the weather condition of blowing sand. To do this you will use the CALCULATE function and FILTER to limit the results. Create a new measure under First_Accident:

           First_Accident_Blowing_Sand:=CALCULATE ( 
             FIRSTDATE(CRASH_DATA_T[CRASH_DATE], 
             FILTER(WEATHER_T,[WEATHER_CONDITION]="Blowing Sand")) 
   

   

Based on the date in the table, the first...