cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anandsoftweb Regular Visitor
Regular Visitor

Find Max data from string/text Data using DAX

Hello All,

 

I have following data 

ID       Item Data          DataValue(String Data)

--------------------------

 1          Item1                  1.0

 2          Item2                  2.x

 3          Item2                  2.5

 4          Item3                  3.0.1

 5          Item4                  4.x

 6          Item5                  5.0.2

 7          Item5                  5.0.5

 8          Item6                  1.2

 9          Item6                  1.2

 10        Item7                  2.0.1

 11        Item8                  9.x

 12        Item8                  8.0

 13        Item9                  7.x

 14        Item9                  7.2

 

Find Max value from DataValue column using dax calculation

 

Output should be Item 8 and 9.x

Note:- GoupBy Item 8 

 

Thanks

 

 

3 REPLIES 3
Super User
Super User

Re: Find Max data from string/text Data using DAX

@anandsoftweb

Create a COLUMN

Data String Rank = RANKX(ALL('Table'), 'Table'[Data String],, DESC)

Then a MEASURE

 

MAX Item Data & String =
CALCULATE (
    FIRSTNONBLANK ( 'Table'[Item Data], 1 ),
    'Table'[Data String Rank] = 1
)
    & " and "
    & CALCULATE (
        FIRSTNONBLANK ( 'Table'[Data String], 1 ),
        'Table'[Data String Rank] = 1
    )

Hope this helps! Smiley Happy

 

anandsoftweb Regular Visitor
Regular Visitor

Re: Find Max data from string/text Data using DAX

@Sean

 

Its not working I have tried for the same Smiley Sad

Highlighted
Super User
Super User

Re: Find Max data from string/text Data using DAX

Display Value and Max String Value.png