Dynamic Ageing
Hello, I am actually working on an AR ageing report. My data model is as follows: I have a AR transaction table with the amount, with a Date filed related to a calendar table. So far, I have managed to get the ageing as at today. I have added a calculated column, to calculate the age of the transaction and have used this measure to make it work: Ageing AR Amount = CALCULATE( PostAR[AR Net], FILTER( DISTINCT(PostAR[Ageing]), COUNTROWS(FILTER('Ageing Group', PostAR[Ageing] >= 'Ageing Group'[Min] && PostAR[Ageing] <= 'Ageing Group'[Max] ) ))) Ageing group table and ageing is as follows: So far so good. However, I need to have the calculated column age as dynamic, so that the ageing report is as at a selected date by the user. I have tried adding the ADDCOLUMNS to caluclated the age based on the date selected, but cannot figured it out.
