The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |