Forum Discussion

sentsara's avatar
sentsara
Icon for Helper II rankHelper II
8 years ago
Solved

DAX Max value from another column based on row value

Hi ,   Need help on DAX Expression to repeat MAX Values of column2 in column3 .   Dataset Name: Measure COLUMN1 COLUMN2   Column3 <DAX Expression needed> 1            25 2             35 3   ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Use this DAX formula:

     

    Column3 = CALCULATE(MAX(Table1[Column2]),ALL(Table1[Column2]))

     

     

    Thanks

    Raj

sentsara's avatar
sentsara
Icon for Helper II rankHelper II
8 years ago

Thanks Rajendran.

IF col2 is calculated expression also ,I think we can apply the same expression. can you confirm on this?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, Calculated column also can be used there.

 

Thanks

Raj