Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello.
I am trying to formulate a calculation to chart the monthly growth withing a rolling 12-month period. The user is able to create the start date. The growth would be from the start date.
How do I create a table showing the value of the earliest date of the period? From there I would calculate the variance.
What function should I use? Thank you for your assistance?
Hi, @ShrimpCreole
Can you elaborate more on how will the user choose the date (slicer or in the backend) and what the final visual would look like?
So, for the below I would like to show the variance and % change from July 2020.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |