Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |