Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
20 | |
13 | |
11 | |
10 | |
8 |