cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Calculate Ageing Days dynamically

Hi,

 

There is one requirement that I need to provide Date as input date in the report. On the basis of that input date I need to calculate the age of my pending invoice. Everywhere I am getting to calculate Ageing days from today but not with the input date. Could you please help.

 

Ageing Days calculation from today can be handled in datamodel, but getting date as input is not possible nto hable in datamodel.

 

Regards

Supriyo

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Calculate Ageing Days dynamically

@supriyomunshi 

 

You can use the What-IF parameter for getting the Day, Month and Year. Then You can calculate the Date using DATE().

InputDate = DATE('Year'[Year Value],'Month'[Month Value],'Day'[Day Value])

Once you have the date, you can easily create a measure for calculating the Aging. 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Calculate Ageing Days dynamically

@supriyomunshi 

 

You can use the What-IF parameter for getting the Day, Month and Year. Then You can calculate the Date using DATE().

InputDate = DATE('Year'[Year Value],'Month'[Month Value],'Day'[Day Value])

Once you have the date, you can easily create a measure for calculating the Aging. 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂

View solution in original post

Highlighted
Community Support
Community Support

Re: Calculate Ageing Days dynamically

HI @supriyomunshi,

You can use date field on slice with range mode(before, after, between), it allows you to click on the textbox to input date value.

13.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!