Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to create a DAX formula that lets me look at Rolling 30 days (from today)
Then another Formula that looks at the Rolling 30 Days before that
So I can Compare them.
I am looking at the Count of customers with Revenue Associated with them.
So far this is what i have:
Hi @mcornfield ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
@mcornfield , Try like
Rolling 30 day = CALCULATE([1. Count of Cust w Rev],DATESINPERIOD('Date'[Date],max('Date'[Date]),-30,Day))
Rolling 30 before 30 day = CALCULATE([1. Count of Cust w Rev],DATESINPERIOD('Date'[Date],max('Date'[Date])-30 ,-30,Day))