The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I tried the solution from other threads in forum but it cant seem to work with mine. I want to get the trailing 4 weeks of my Actual, this actual is in MEASURE, here is the formula for that
I thought I solved this one, but when I checked it again it isnt showing any output here is the formula of my trailing 4 weeks average
And I dont want it to be included in getting the Trailing 4 weeks averages
I hope someone can help me. Thank you!
This is my expected results
that is in excel, that is for total of all the lines, there is also for individual.
First ff
I have a calendar table
this is the formula I used for that.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
7 |