Forum Discussion

InsightSeeker's avatar
InsightSeeker
Icon for Helper III rankHelper III
2 years ago

Modification of DAX for Aging Calculation Based on Selected Month

I have created the following DAX to calculate the aging as of TODAY. Now, I need to modify this DAX to calculate the aging as of the Selected Month (Last Day of the month). How can I accomplish this?...
Need Help
Show and Tell
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

In your model you linked the caledar table to the invoice date so when you select a month you are only looking at invoices in that month.  That doesn't allow for the dynamic behavior you are looking for.  The due date will always be later than the month you selected (due date is always after invoice date).

  • InsightSeeker's avatar
    InsightSeeker
    Icon for Helper III rankHelper III
    2 years ago

    jdbuchanan71  - Even if i change my model from inv date to the due date, still I don't get the desired results. My result always show 0 for all.