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
my data set like below we have enter the March Month value in Apirl and April Month value enter May month like below
Month Period Values
March 01-04-2019 45
April 01-05-2019 23
May 01-06-2019 23
...
....
...
August 01-09-2021 23
Sep 15-09-2021 34
last upto now entered value sep 15 data . how to current year (2021 ) compare to previous year (2020) based Month and year (period) any idea ..thanks in advance .
Hi @Anonymous
You can use SAMEPERIODLASTYEAR in your measure to find the value in the same month last year.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
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!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 21 | |
| 20 | |
| 20 | |
| 14 | |
| 14 |