Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
@Anonymous
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 🙂
HI @Anonymous,
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.
Regards,
Xiaoxin Sheng
@Anonymous
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 🙂