Forum Discussion

Hengqiiiiii's avatar
Hengqiiiiii
Frequent Visitor
7 years ago
Solved

Specific Text Reference in PowerBI

Hi, currently I am struggling with text reference in PowerBI. I would like to create a card function in PowerBI, which shows the text in a specific cell from excel database. The text in the cell will...
Need Help
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Hengqiiiiii,

     

    I made one sample for your reference. Here we need to add an index column in excel or power query. Then you can use the measure as below to achieve your goal.

     

    Measure = CALCULATE(MAX(Table1[E]),FILTER(Table1,Table1[index]=3))

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Hengqiiiiii,

 

I made one sample for your reference. Here we need to add an index column in excel or power query. Then you can use the measure as below to achieve your goal.

 

Measure = CALCULATE(MAX(Table1[E]),FILTER(Table1,Table1[index]=3))

For more details, please check the pbix as attached.

 

Regards,

Frank

 

 

  • Hengqiiiiii's avatar
    Hengqiiiiii
    Frequent Visitor
    7 years ago

    Hi Frank, thank you so much for your kind help! It is really useful and I am so grateful that you take time to help me solve the problem!

     

    Best wishes,

     

    Hengqi