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.
I wrote this code to calculate the delta ( Diffrance )between the current year for the current month from the previos year for the same month BUT unfortunately it gives me sysntax error "," Can you please help to figure out where is the problem and how to solve it
Delta =
VAR CurrentMonth = MONTH(TODAY())
VAR CurrentYear = YEAR(TODAY())
VAR PreviousYear = CurrentYear - 1
RETURN
CALCULATE(
SUM(Sales[Amount]),
SAMEPERIODLASTYEAR('Date'[Date]),
YEAR('Date'[Date]) = PreviousYear,
MONTH('Date'[Date]) = CurrentMonth
) - CALCULATE(
SUM(Sales[Amount]),
YEAR('Date'[Date]) = CurrentYear,
MONTH('Date'[Date]) = CurrentMonth
)
Thanks.
Solved! Go to Solution.
Hi,
it's actually an error with the variable 'PreviousYear ' this is a reserved word - if you change it and the references to it in the measure it will work.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
it's actually an error with the variable 'PreviousYear ' this is a reserved word - if you change it and the references to it in the measure it will work.
If I answered your question, please mark my post as solution, 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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |