Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |