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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

undefined

how do i get the count for 12 months ago 

 period beginning period end 
Jan-221908119628
Feb-222799914734
Mar-227030893749
Apr-221197575096
May-223481315821
Jun-226577838651
Jul-224656754489
Aug-221473413678
Sep-229374930216
Oct-227521326921
Nov-221582016352
Dec-222309523019

 

 

 

the output should be something like this:

 

period period beginning period end  12 months ago
Jan-22190811962819081
Feb-22279991473427999
Mar-22703089374970308
Apr-22119757509611975
May-22348131582134813
Jun-22657783865165778
Jul-22465675448946567
Aug-22147341367814734
Sep-22937493021693749
Oct-22752132692175213
Nov-22158201635215820
Dec-22230952301923095

 

Thanks 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous 

Can you provide more detail inforation, from the output you want, the "12 month ago" column  is the same as the "peroid beginning" column.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ribisht17
Super User
Super User

Not clear,

 

 

Ritesh

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors