topic Help required on Aging and duration in power bi dax in DAX Commands and Tips

Help required on Aging and duration in power bi dax

Anonymous — Fri, 12 Jan 2024 12:18:11 GMT

Hi Team,

I need to calculate duration and aging based on the dates selected from the slicer Dateslicer (we used option as Between)

We are having fields like startdate and enddate columns in the source table.

Requirement

Slicer :

Duration in Days Calculation

For example: We are having

Startdate Enddate

01-Jan-2024 10-Jan-2024

We need to calculate duration for above record is diffference between these two dates :01-jan-2024 & 08-jan-2024 because we selected enddate as 8-jan-2024 from the slicer

Always StartDate>=Selected date from slicer

Enddate should be : <= selected date from the slicer

Power bI File Link : AgingDuration.pbix

Thanks,

Deva.

Re: Help required on Aging and duration in power bi dax

lbendlin — Sun, 14 Jan 2024 23:50:44 GMT

You can let the data model help you, with USERELATIONSHIP

What's your formula for aging?

Re: Help required on Aging and duration in power bi dax

Anonymous — Tue, 16 Jan 2024 11:50:14 GMT

Hi lbendlin ,

I've created relation in data model and created measure for duration.

We are using matrix visual to show the data . Duration is showing correctly in the detail level( last drill down level) while we drill up to above level duration showing wrong values(means its not summing up the data)

For example:

Deatil Level

These duration values(Highloghted in yellow) are calculating correctly

Drill Up Level

When we drill up the data showing wrong value )highlighted yellow)

we need to show : sum of 4.94+1.11

I tried in my way but unable to solve the issue . Can you please help on the same?

Measure name created in the attached file is: Duration_Day

Power file Link: AgingDuration.pbix

Thanks,

Deva.

Re: Help required on Aging and duration in power bi dax

lbendlin — Wed, 17 Jan 2024 23:45:27 GMT

Your slicer should be fed by a proper calendar table, not by

DISTINCT(Sheet1[StartDate])

Re: Help required on Aging and duration in power bi dax

Anonymous — Mon, 29 Jan 2024 09:52:57 GMT

Hi Anonymous ,

Can't open the pbix file you shared, please re-share it in another way and I'll get back to you as soon as possible.

Best Regards,
Adamk Kong

Re: Help required on Aging and duration in power bi dax

Anonymous — Mon, 29 Jan 2024 13:34:55 GMT

Hi v-kongfan-msft ,

Requirement was resolved by myself. Thanks for your message.