Date Diff start date not required to preceed end date

[kevin_adams09]

The DATEDIFF function in Power BI DAX, should not require the start date arg to preceed the date given the end date arg. The DATEDIFF function in SQL does not impose this requirement. This would make implementing the DATEDIFF arg in a date dimension table (with dates going into the future) much easier. Currently the DATEDIFF must be wrapped in an IF statement to work correctly. Finally, it would seem like this could be fixed by having DATEDIFF in Power BI DAX return a signed, rather than unsigned integer.

[ssoni1]

I too have similar situation while working on the Dashboard for Network Scehculde for project Plan; This make it simpler to write DAX

[a_nagel]

I would suggest making a new function to ensure existing reports keep working

[foxan]

Since when has this been rolled out without notice?

[fbcideas_migusr]

Datediff now returns a negative value so this has been implemented? No notice?!

[josh_flory1]

However... I don't think this change was done for SSAS Tabular as DATEDIFF there still returns the same error...?

[wanthanaj1]

It had been working in SASS since Jan 2018 until yesterday (May 2019 I updated my VS 2017).