Forum Discussion
Date Calculator
Hi mwen90,
the DAX function DATEDIFF definition can be found here: https://docs.microsoft.com/en-us/dax/datediff-function-dax It says, the first param is StartDate and the second is EndDate. I think you should change the order in your Days expression.
Days = DATEDIFF(PlantEuipment_PlantEquipment[LastServiceDate];Today();DAY)
Then change the data type of LastServiceDay to date/time:
And I've also extend your DaysGroup logic to:
DaysGroup = IF ( PlantEuipment_PlantEquipment[Days] < 0; BLANK (); IF ( PlantEuipment_PlantEquipment[Days] <= 80; "Within service date"; IF ( PlantEuipment_PlantEquipment[Days] <= 90; "Approaching service date"; IF ( PlantEuipment_PlantEquipment[Days] > 90; "Service Required" ) ) ) )The result:
Nolock thank you. I have been able to apply this, but I am still seeing records which aren't +90 days
Thank you so much for the help!
Hi mwen90,
just for debugging purpose: Please add the column Days to your table to see what values are there.
Hey Nolock thank you for that,
I can see the calculations are wrong. Is it something in the formula?
Hi mwen90,
have you renamed the column LastServiceDate to "Last Service Date" in your visual or do you have 2 different columns in your table? Have you taken the right column from the right table? Please check it or even better write the calculate column DAX code once again from scratch. I think you calculate DATEDIFF with a wrong column.