Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |