Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
DAX
variables
  • VahidDM's avatar
    VahidDM
    5 years ago

    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✌️!!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.