Forum Discussion

Cazzagg's avatar
Cazzagg
Advocate I
10 years ago
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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    10 years ago

    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.

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
10 years ago

You could create a view over your data in the SQL Database and use that as a source for Power BI

 

in the view you could use the SQL DateDiff function.    Something like: 

 

SELECT
DATEDIFF(DAY,[Actual Response Date],[Target Response Date]) AS NoOfDays,
*
FROM RestOfQueryHere.....

Cazzagg's avatar
Cazzagg
Advocate I
10 years ago

That's a good option too. Thank you 

 

i will let you know how I go. Thanks again for taking the time to answer. Really appreciate it