Forum Discussion
Helper IIIModification of DAX for Aging Calculation Based on Selected Month
Super UserBased on your selection of Aug-23, what would you want to see in the aging column? It's not clear to me what you are trying to accomplish.
InsightSeekerHi jdbuchanan71 - When you click on Aug '23, the aging should be calculated from the due date as of the last day of Aug '23, and it should display all transactions. When the slice is used, only the aging is changed based on the month selected. It should display all transactions.
Criteria:
- If you have selected Aug '23, the result should be:
- If the month difference between the due date and Aug '23 is 0 or less, it should be in the "Current" bracket.
- If the month difference between the due date and Aug '23 is 1, 2, or 3, it should be in the "1 Month" bracket.
- If the month difference between the due date and Aug '23 is equal to 4 or less than or equal to 6, it should be in the "4-6 Month" bracket.
- If the month difference between the due date and Aug '23 is equal to 7 or less than or equal to 9, it should be in the "7-9 Month" bracket.
- If the month difference between the due date and Aug '23 is equal to 10 or less than or equal to 12, it should be in the "10-12 Month" bracket.
- If the month difference between the due date and Aug '23 is greater than 12, it should be in the "Above 12 Month" bracket.I hope the above is clear. Please feel free to let me know if you need more information.