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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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