PowerBI Datediff

[sid-agarwal]

I am trying to create data card on PBI report which shows the average time (in days) it takes to get the approval from the time the entry was created, which approval1Date Minus (-) the CreatedDate.
I tried using the datediff fuction but it is not pulling the date column for some reason.

[sid-agarwal]

@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. 

[ahmedoye]

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.

[ahmedoye · Accepted solution]

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.