Forum Discussion
Help with DAX
Hello, I'm trying to create a measure that shows the following: Rotulo_ano =
VAR AnoMax = CALCULATE(MAX('dCalendário'[Ano]),ALL('dCalendário'[Ano]))
VAR AnoSelec = CALCULATE(MAX('dCale...
Hi Anonymous
Use HASONEVALUE or SELECTEDVALUE in your code.
Try this measure:
Rotulo_ano = VAR AnoSelec = CALCULATE(MAX('dCalendário'[Ano])) return IF(HASONEVALUE('dCalendário'[Ano])," em " & AnoSelec," até " & AnoSelec,)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
VahidDM
Super User
Super UserHi Anonymous
Use HASONEVALUE or SELECTEDVALUE in your code.
Try this measure:
Rotulo_ano =
VAR AnoSelec = CALCULATE(MAX('dCalendário'[Ano]))
return
IF(HASONEVALUE('dCalendário'[Ano])," em " & AnoSelec," até " & AnoSelec,)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!