Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 )
User | Count |
---|---|
72 | |
70 | |
37 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |