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,
I am trying to calculate rolling sum. There are few of categories missing in some of the years, my requirement is If i select year 2022 i should get rolling sum of all categories present in 2021 & 2022 in "2022" row in matrix same for 2023 row i should get rolling sum of all categories present in 2021,2022 & 2023 in 2023 row.
but i am only getting rolling sum for categories which are present in 2022 in 2022 row. Actual & Expected outputs, measere formula with data are attached below. Can someone please help me with this.
Solved! Go to Solution.
Hi @Anonymous ,
I would always recommend the use of a date table.
Have a look at the attached sample file.
Hi All,
This is extention of my previos question, is there a possibility that Total column/Row total should only totals for A & D categories but not remaining categories. Thanks in advance.
Hi @Anonymous ,
I would always recommend the use of a date table.
Have a look at the attached sample file.
Hi Marcus Wegener ,
Thank you very much for the solution and suggestion. Really appreciate it.
Yes. Without dimension tables, auto-exist is going to cause all kinds of trouble in this sort of scenario.
Hi,
Thank you very much. Appreciate it.
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 |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |