Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
latheesh89
Helper II
Helper II

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

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

1 REPLY 1
Anonymous
Not applicable

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

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.