topic Help to return the value (text) in column in table in DAX Commands and Tips

Help to return the value (text) in column in table

Anonymous — Mon, 09 May 2022 12:48:08 GMT

I have a table with a few columns. One is a value column (call it Column 4) and I have created a DAX formula to find the MAX in that column.

I want to return the value, which is TEXT, from column 5 that corresponds to the row in column 4 from the MAX formula.

How do I do this. It's simple in Excel.

Please help.

Greg_Deckler — Mon, 09 May 2022 12:55:25 GMT

Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Anonymous — Mon, 09 May 2022 13:11:39 GMT

Hi Greg

Thank you. See example data below. I hope this helps you to help me.

I have a DAX Measure to find the MAX of 'No. of issues' column (

= MAXA('Sense Check Checklist'[No of issues]). This works fine.

Using this measure, I am wanting to return the TEXT in column F, i.e., Bank Ops

Basically, in xlsx the formula would be =IF(C244=MAX($C$2:$C$294),F244)

tamerj1 — Mon, 09 May 2022 14:41:42 GMT

Hi Anonymous

you may try

MAX ID = CALCULATE ( MAX ( 'Sense Check Checklist'[ID] ), 'Sense Check Checklist'[No of issues] = MAX ( 'Sense Check Checklist'[No of issues] ) )

Anonymous — Mon, 09 May 2022 15:03:35 GMT

That's great, Thank you tamerj1

I too found a solution by creating a New column:

MAX ID Column = IF('Sense Check Checklist'[No of issues] = MAXA('Sense Check Checklist'[No of issues]), 'Sense Check Checklist'[ID]) 😀

Anonymous — Mon, 09 May 2022 15:03:06 GMT

Apologies.

Thank you tamerj1