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.
What is your datasource? Are you getting the data from an SQL DB?
Yes the data is from a SQL database
