Forum Discussion
PowerBI Datediff
Because you are creating this as a Measure and not as a Calculated Column, you may not get the right behavior.
What you probably want to do is to create the formula as a calculated column, or use a Measure that is like:
AVERAGEX(YourTable, DATEDIFF(YourTableColumn1, YourTableColumn2, DAY))
If this works for you, kindly mark as answer to make it easier for anyone with similar issues to find the solution.
ahmedoye
Hi,
your solution was working fine until today but suddenly the visual broke and gave me this error. Can you think of something what could have done that?
(I created a new date table [foolwing another query about PBI] https://community.fabric.microsoft.com/t5/Desktop/Custom-Date-drop-down-slicer/m-p/4591075#M1377166)
and created a relationship between the "CREATED" column in my main tables and DATE Table. Did nothing to the visual that broke.
Hi sid-agarwal , from what I see here, you just need to remove the parts in the formula that have ".date". Those undelines and you will be fine.