Forum Discussion

mthukara's avatar
mthukara
Frequent Visitor
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     Create a calculated column with following DAX formula

     

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

     

    Thanks and Regards,

    Neha Rajgadkar| BI Consultant

    Nice Software SolutionsPvt. Ltd.