Forum Discussion

Aleksis's avatar
Aleksis
Regular Visitor
3 years ago

DATEDIFF presenting wrong results

Hello,   I'm quite new to PowerBI and have been trying to solve a problem related to date differences. I have looked into other posts but none of the solutions presented worked for me.   I have a...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Aleksis ;

First of all, you can't create columns in LC mode, the following is my formula, you can try it.

Number of days overdue =
SUMX (
    SUMMARIZE (
        'PROJECTS',
        [Due_Date],
        "1", DATEDIFF ( [Due_Date], TODAY (), DAY )
    ),
    [1]
)

If it doesn't solve your problem, can you share a simple data and hope to output the result? Judging from the pictures, there is no problem with the result returned by your formula? So more information can be provided.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Aleksis's avatar
Aleksis
Regular Visitor
3 years ago

Unfortunately, your formula gave the same output as mine so I wasn't able to resolve the issue. Could you please explain more what you mean by "can you share a simple data and hope to output the result"?