Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 12 | |
| 9 | |
| 8 | |
| 7 |