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 have a serie of measure that always have the same format. I would like to use variables so that when I copy a measure, I always have to only have to change the measure that is refered in it once. But, when I try, it returns 0. What am I doing wrong?
Noto POND (-1 an) =
var mesure = [Noto POND TOTAL]
return
CALCULATE(
mesure;
SAMEPERIODLASTYEAR(
DATESBETWEEN(
'Table Dates'[Date];
DATE(YEAR(LASTNONBLANK ( 'Table Dates'[Date];mesure));01;01);
DATE(YEAR(LASTNONBLANK ( 'Table Dates'[Date];mesure));12;31))
)
)
Hi @KaterineCAA , try it this way.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Noto POND (-1 an) =
VAR mesure = [Noto POND TOTAL]
VAR _calc =
CALCULATE (
mesure;
SAMEPERIODLASTYEAR (
DATESBETWEEN (
'Table Dates'[Date];
DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date]; mesure ) ); 01; 01 );
DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date]; mesure ) ); 12; 31 )
)
)
)
RETURN
_calc
Proud to be a Super User!
Thanks for your reply @Nathaniel_C
However, it doesn't work. I've tried with a simpler measure.
MESURE TEST (année en cours) =
VAR mesure = [Noto POND TOTAL]
VAR _calc = DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date] ; mesure ) ) ; 01 ; 01 )
RETURN
_calc
This mesure returns 2020-01-01 and the next one, returns 2019-01-01 (which is what it should be)...
MESURE TEST (année en cours) =
VAR _calc = DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date] ; [Noto POND TOTAL] ) ) ; 01 ; 01 )
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |