Power BI AR Aging Buckets

Question

In Power Bi I am building a aging report with 30,60,90 and 120 buckets everything works fine until I sorted the report into buckets.So when I enter as a date in slicer it should balance accordingly and balance should display in  appropriate bucket.

So How can I able to solve this?

Answer 1

Use the following measure:

From 01 to 29 days = CALCULATE([Due Amount]
,FILTER('BDW Account Receivable',DATEDIFF(min(Calender[Date]),'BDW Account Receivable'[DueDate],DAY)>-30 
                              && DATEDIFF(min(Calender[Date]),'BDW Account Receivable'[DueDate],DAY)<0))

Want to learn more about Power BI? Check out today: Power BI course