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.
I need help calculate the variance between last week's sales vs. the average total of the prior 6 weeks. I've seen and found formulas that does it by day but my data only comes in fiscal weeks (Sun-Sat). Please Help!
Goal 1: Total last weeks sales - Avg. Total of prior 6 weeks = $ Variance
and
Goal 2: Total last week sales / Avg. Total of prior 6 weeks -1 = % Variance
Solved! Go to Solution.
Hi, @hibarrbm
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
all measures are written in the sample pbix file.
https://www.dropbox.com/s/vd7ztj87pqs58m7/hibarrbm.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @hibarrbm
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
all measures are written in the sample pbix file.
https://www.dropbox.com/s/vd7ztj87pqs58m7/hibarrbm.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
This worked perfectly! thanks so much
Just to clarify, i really only need help calculating the Avg. Total for last 6 weeks
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |