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     🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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