Date Diff Dax showing incorrect difference in some Tags

[NavaneethaRaju]

Hi ,

I created a measure for finding the datedifference. it showing incorrect difference in some places.

Date Diffe = DATEDIFF('Tag Usage Fact'[Order Date],TODAY(),DAY)

The correct difference is 67. from 17-06-2022 to Today.

Please advice how to rectifiy this.

[Anonymous · Accepted solution]

Hi @NavaneethaRaju ,

Try this
Date diff = 

DATEDIFF('TableName'[Date],Format(TODAY(),"dd-mm-yyyy"),DAY)

Regards,

Ashfiya

--------------------------------------------------------------------------------------------------------------------------

Did I help you today? Please mark my post as a solution and hit the Kudos button.