DAX formula to calculate last 30 days, 60 days and above 90 days

[latheesh89]

Dear Techie,

I have a requirement where I need to calcuate "Accounts Receivable" for last 30 days, 60 days and above 90 days

By default the above should work from Today's date (End Date) . But suppose if I choose any date from the date filter the End Date must be the date I selected.

Can someone help me out with this?

Thanks,

Latheesh

[Anonymous]

If you have the Date table in your design, you can use that date to calculate this and the filter also should be based on this date column.

Example : CALCULATE(SUM(Sales_Fact.Sales),DATEADD(Dates[Date],-30,DAY)

Thanks

Raj