Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Wrong outcome using DATEDIFF

In the screenshot below you can see my Power BI page. I want to calculate the days between two dates. I want to have the number of days from VALIDFROM to Tot Datum. But when the Tot Datum is not with...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , this seems like a column. You can not use slicer for column

Create a measure like

Tijd in Leegstand = DATEDIFF(max('PMCCONTRACT'[VALIDFROM]),[Test],DAY)+1