Solved: Date Calculator - Page 2

mwen90 · ‎07-28-2019

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 if statements (pic 2)

But if I look at the table, my data is still wrong as it has data from this month. (pic 3)

I am not sure where I have gone wrong,

Cheers,

Nolock · ‎07-30-2019

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:

View solution in original post

Date Calculator

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024