cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Calculating Age [Direct Query]

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

 

 

4 REPLIES 4
danextian New Contributor
New Contributor

Re: Calculating Age [Direct Query]

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) 

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

Re: Calculating Age [Direct Query]

Hi there,

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

 

 

danextian New Contributor
New Contributor

Re: Calculating Age [Direct Query]

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

Re: Calculating Age [Direct Query]

I'm not sure I know how to be honest, could you point me in the right direction?

 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 315 members 3,175 guests
Please welcome our newest community members: