Forum Discussion

mwen90's avatar
mwen90
Helper III
7 years ago
Solved

Date Calculator

Hey,    I am trying to do a report to show me any items whereby the entered date is +90 days.    I have created a column to calculate the data date to today's date.  I have then done some ...
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    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:

mwen90's avatar
mwen90
Helper III
7 years ago

Hey Nolock thank you for that, 

 

I can see the calculations are wrong. Is it something in the formula?

Nolock's avatar
Nolock
Resident Rockstar
7 years ago

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.