Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

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 🙂