Forum Discussion
Date diff with duplicate values
Hello all, I am trying to create a calculated column that gives the age (in days) between a date in a column and the current date. I then want to create an additional measure based on this one. T...
Hi socal225 ,
What are the other measures?
You can Calculated Columns
Days Elapsed = DATEDIFF('Table'[DateTime],Today(),DAY)
Ageing = IF (Table[Days Elapsed] > 50, "above 50 Days", "Below 50 Days")
and then create a measure
Ageing Details = COUNT(Table[RecordNo])
Regards,
Harsh Nathani