Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @THENNA_41
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✌️!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |