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
mthukara
Frequent Visitor

Need Help on DAX Formula

I need help in DAX formula for the below scneraio;

 

I have Category and value column, i need a Max value column which will repeat the max from val column irrespective of category.

 

In the below example 499 is the maximum value in val column and 499 should be for each record in max val column.

 

 

CategoryValMax Val
Cat1242499
Cat2499499
Cat3464499
Cat4104499
Cat5437499
Cat6131499
Cat7416499
Cat8156499
Cat9473499
Cat10295499
Cat11173499
Cat12478499
Cat13305499
Cat14478499
2 REPLIES 2
amitchandak
Super User
Super User

@mthukara ,

Try like

Max Val =
var _max = maxx(Table,Table[Val])
return
_max
neha369
Helper I
Helper I

 Create a calculated column with following DAX formula

 

Max Val = MAX('Table'[Val]) 

 

Thanks and Regards,

Neha Rajgadkar| BI Consultant

Nice Software SolutionsPvt. Ltd.

 

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.

Top Solution Authors