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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
how do i get the count for 12 months ago
| period beginning | period end | |
| Jan-22 | 19081 | 19628 |
| Feb-22 | 27999 | 14734 |
| Mar-22 | 70308 | 93749 |
| Apr-22 | 11975 | 75096 |
| May-22 | 34813 | 15821 |
| Jun-22 | 65778 | 38651 |
| Jul-22 | 46567 | 54489 |
| Aug-22 | 14734 | 13678 |
| Sep-22 | 93749 | 30216 |
| Oct-22 | 75213 | 26921 |
| Nov-22 | 15820 | 16352 |
| Dec-22 | 23095 | 23019 |
the output should be something like this:
| period | period beginning | period end | 12 months ago |
| Jan-22 | 19081 | 19628 | 19081 |
| Feb-22 | 27999 | 14734 | 27999 |
| Mar-22 | 70308 | 93749 | 70308 |
| Apr-22 | 11975 | 75096 | 11975 |
| May-22 | 34813 | 15821 | 34813 |
| Jun-22 | 65778 | 38651 | 65778 |
| Jul-22 | 46567 | 54489 | 46567 |
| Aug-22 | 14734 | 13678 | 14734 |
| Sep-22 | 93749 | 30216 | 93749 |
| Oct-22 | 75213 | 26921 | 75213 |
| Nov-22 | 15820 | 16352 | 15820 |
| Dec-22 | 23095 | 23019 | 23095 |
Thanks
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.
Not clear,
Ritesh
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!