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('dCalendário'[Ano]))
return IF(AnoMax = AnoSelec," até " & AnoSelec, " em " & AnoSelec)
If I don't select any year, it shows me "até" (until in Portuguese) the last year. If I select another year, like 2019, it shows me "em" ("in") that specific year. But if I select the last year, which is 2021, it shows me "até", and I want to show me "in" instead because I'm not selecting the whole period.
Nothing selected:
Nothing selected
2020 selected:
2021 selected:
Is there any way I can tell PBI that when I'm selecting a year, even if it's the latest one, it should show me "em"?
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✌️!!
2 Replies
- VahidDM
Super User
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✌️!!
Hello, VahidDM.
Thank you for your help. It worked as it should and expected. I'll search a little bit more about the functions you wrote.