Forum Discussion

Surendra_thota's avatar
Surendra_thota
Icon for Helper II rankHelper II
9 years ago

DateDiff Days giving incorrect result

Hi All   we need to calculate number days between  [next reading due date]  and Report genertion date  (  Instead of Today () , we are taking a measure from Date dimenion to get max input date from...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
9 years ago

That is super weird, and I am mostly commenting just so I can follow along :D

My only thought would be to try to wrap CALCULATE( )  around your call to DATEDIFF.

Surendra_thota's avatar
Surendra_thota
Icon for Helper II rankHelper II
9 years ago

Hi Scottsen

when i use today() function i am getting correct value 

Days Due  = View_Compliance[Next Reading Due By]- Today()

 

but when i want use a constant date ie selected from input slicer , it is nota accepting , even i tried to give max reportiondate as measure  as well directly as shown below but bothcases it is taking only last value of the genetation date table value but not slected value.

 

Days Due Column = View_Compliance[Next Reading Due By]- MAX('Report Generation Date Table'[Report Generation Date])

 

How to pass a slected date value from slicer used in difffrent table as variable