Re: Calculating Age [Direct Query]

Anonymous · ‎03-22-2018

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

danextian · ‎03-22-2018

Hi @Anonymous,

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)

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Anonymous · ‎03-22-2018

Hi there,

no, specifically direct query. I'm pulling data from a live database.

danextian · ‎03-22-2018

Have you tried creating a custom column that subtracts the start from end date?

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.