Hello All,
For some background, I created a measure that finds the last day of the previous month using EOMONTH function then used that to substract a specific date to finds the number of days between both dates. I then created aging buckets based on that to find the specific amount for each bucket using an if statement like these 2 buckets for example.
0-30days = IF([days]<=30,SUM('Table'[Amount ])))
1-2years = IF([days ]>365 && [days]<=730,SUM('Table'[Amount]))
Let's say the level of details I have is Super group and group, super group being higher, when I do the calculations above, the super group level just sums eveything to the last bucket without distributing to the appropriate buckets but the group shows the sums in the right buckets.
The issue is that I want the sums at the higher level which is the super group. any ideas would be much appreicated?
Thank you,
Sophie
