Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to calculate the age of events but using direct query is very different than the reports I've done from spreadsheets in the past. Can someone help me please?
I have Task_Created_Date which shows the date format as xx/xx/xxxx
Hi @johnbradbury,
Are you referring to Power Query instead of Direct Query?
Calculating age can be achieved by using creating a calculated column in DAX.
DATEDIFF( start date, end date, interval)
Proud to be a Super User!
Hi there,
no, specifically direct query. I'm pulling data from a live database.
Have you tried creating a custom column that subtracts the start from end date?
Proud to be a Super User!
That will not work with Direct Query?
I'm not sure I know how to be honest, could you point me in the right direction?
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |