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

[Anonymous]

Hi

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.

[Anonymous]

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 · Accepted solution]

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]

Apologies.

Thank you tamerj1

[Anonymous]

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])  😀

[Greg_Deckler]

@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.