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
hannibalmads's avatar
hannibalmads
Icon for Advocate III rankAdvocate III
3 years ago

You should try to add a calculated column instead. Datediff(due date, today(), DAY) should work then. The data type seems to be a date otherwise the datediff function would fail. The wrong numbers I assume is a result of summarising all the projects of equal due date. 

  • Aleksis's avatar
    Aleksis
    Regular Visitor
    3 years ago

    I assume I can't make a calculated column because I'm using a live connection. You mentioned that the wrong numbers are a result of summarising all the projects of equal due date. Is there a way to avoid this?