Help with Classifying amounts at the bucket level

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

Forum Discussion

Help with Classifying amounts at the bucket level

Related content

Power Query Add rows of zero amount

Creating custom buckets for spend amount

Amount breakdown in 13 week bucket

Dynamic Buckets based on slicer

Dynamic Buckets