Forum Discussion
Solved
DATEDIFF question
Hi All I am extremely new to all this so please forgive me my ignorance...... I have two date fields in my table– one for the target response date and one for actual response date - I am try...
That sounds like a feature where Power BI is offering you some Time Intelligence over your datetime column.
It has recognised your "Actual Response Date" column is a date, and it's building a hierarchy on the fly to allow you to drill up and down on visuals that offer visuals (eg, Bar and Column).
There should be a small 'x' to allow you to remove the levels in the hierarchy. It can be a handy feature but you don't always want it.
Can you screen shot the error?
Or perhaps try something like this,
NoDays =
DATEDIFF (
DATEVALUE ( "Actual Response Date" ),
DATEVALUE ( "Target Response Date" ),
DAY
)However, that would not work if the fields are set at dates only if they are set as text.