Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
v_mark
Helper V
Helper V

Month number up to 36 months

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 Number2020
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 
2 REPLIES 2
amitchandak
Super User
Super User

@v_mark , after 12 months data is repeating, what is the advantage of 36 months

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.