Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anandsoftweb
Helper II
Helper II

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
Sean
Community Champion
Community Champion

@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

 

@Sean

 

Its not working I have tried for the same 😞

Display Value and Max String Value.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.