Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I do have a date table that has Month number 1 -12. I'll be needing to have a Month number that is up to 36 months
from there I will calculate the running total. My problem is I don't know how to extend those Month numbers up to 36.
Is there a way to extend the month number perhaps adding an additional column in my date table?
Expected results below
Month Number | 2020 |
1 | $ 20,596.06 |
2 | $ 45,126.28 |
3 | $ 91,347.39 |
4 | $ 174,197.00 |
5 | $ 226,621.92 |
6 | $ 298,256.10 |
7 | $ 422,952.74 |
8 | $ 553,579.03 |
9 | $ 734,440.15 |
10 | $ 937,718.69 |
11 | $1,105,015.87 |
12 | $1,226,298.16 |
13 | $1,375,038.69 |
14 | $1,546,216.62 |
15 | $1,753,902.65 |
16 | $1,889,725.98 |
17 | $2,002,068.64 |
18 | $2,130,545.84 |
19 | $2,223,063.92 |
20 | $2,357,583.06 |
21 | $2,434,629.84 |
22 | $2,486,820.98 |
23 | $2,530,541.92 |
24 | $2,580,289.75 |
25 | $2,615,467.65 |
26 | $2,655,319.38 |
27 | $2,671,632.88 |
28 | |
29 | |
30 | |
31 | |
32 | |
33 | |
34 | |
35 | |
36 |
I updated the view above. I just realize that just the number of months will do and yes my bad the example above is just used as a representation.
pretty much a running total for 36 months that has an indicator on the left side 1-36
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |