Forum Discussion

Gaurav_Lakhotia's avatar
Gaurav_Lakhotia
Helper III
5 years ago
Solved

Calculated Column for Latest Training Date

Hi All,   I need help in calculating the calculated column for latest date.   Scenario is, There is a TrainingTracker table which has Date column (i.e. Training Date). I need to find out the da...
calculated column
Dax Help
Need Help DAX
  • amitchandak's avatar
    amitchandak
    5 years ago

    Gaurav_Lakhotia , From what I got.

    You can have new column which tell diff from last training and you can use that

    new column =
    Datediff( maxx(filter(table ,[Customers Name] = earlier([Customers Name]) && [TrainingDate] <earlier([TrainingDate])),[TrainingDate]),[TrainingDate],day)

  • Gaurav_Lakhotia's avatar
    Gaurav_Lakhotia
    5 years ago

    Hi amitchandak ,

     

    The DAX you've shared is calculating by taking very first Customer Training date as a base.

     

    We want it to consider every corresponding training date of each row to search within 28 days after training.

     

    Thanks

Gaurav_Lakhotia's avatar
Gaurav_Lakhotia
Helper III
5 years ago

Hi amitchandak ,

 

The DAX you've shared is calculating by taking very first Customer Training date as a base.

 

We want it to consider every corresponding training date of each row to search within 28 days after training.

 

Thanks

amitchandak's avatar
amitchandak
Super User
5 years ago

Gaurav_Lakhotia , Please find the file attached after the signature. I created 2 columns to see if those can help.

Column names are different as they did not get pasted correctly