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.
Hi All,
Looking for suggestions/help. I have to created % measure column by using two separate measures for weekly metric, now need to create another column as four week sliding average.
Condition is “N/A” to be ignored, should consider only earlier week which is having numbers as well as 0% to be included for Average Calculation.
required an average over the last four available weekly results.
Existing Column for weekly reporting
Below example for reference
If I am selecting current week i.e 11/11/2019
Avg for WW:
11%+20%+34%+33%= 97% !! Avg will be (97%/4)=24%
where as Avg for Latin America should be:
50%+100%+0%+N/A+N/A+33%=183%!! Avg should be (183%/4)=45.75%
Thanks & Regards,
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 |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |