Forum Discussion
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...
Hi Dale
I have tried as you said , atleast now we are not getting any issue but not giving correct answer , please see the attached screenshot , i took the report generation date as 1st jan 2017 ,
Hi,
The result is correct in some way. It seems that you used the formula as a calculated column. So "MAX ( 'Report Generation Date Table'[ReportGeneration] )" is always the same. It's "2018-12-31" in your table. You have to use it as a measure if you want it to respond to the slicer. Finally, create a report with the measure. Please have a try.
Best Regards!
Dale