Forum Discussion

Rachel_tsao's avatar
Rachel_tsao
Frequent Visitor
5 years ago
Solved

Create a measure return a text

Hi All,

 

I have a question for how to let Measure feedback a Text  which will be changes according to raw data,

for example  I wish  the measure can reture the [Version] which connecting to [Note] as "Current Lock"

in below table , the measure will return a text" Q2 Locked Forecast".

 

I can't figure out what DAX for this measure, can someone help me?

Thanks !

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Rachel_tsao 

    I am not sure if I understand you correctly, you can create following measure:

     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Rachel_tsao , Create a new measure like

    measure ="Q" & calculate(max(Table[order]) , filter(Table,Table[lock]= "Current Lock")) + " Locked Forecast"

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Rachel_tsao 

    I am not sure if I understand you correctly, you can create following measure:

     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.