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            70

4           15

5           45

 

expected output:

 

COLUMN1 COLUMN2   Column3 <DAX Expression needed>

1            25                       70

2             35                      70

3            70                       70

4           15                       70

5           45                         70

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Use this DAX formula:

     

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

     

     

    Thanks

    Raj

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Use this DAX formula:

     

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

     

     

    Thanks

    Raj

    • sentsara's avatar
      sentsara
      Icon for Helper II rankHelper II

      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

        Yes, Calculated column also can be used there.

         

        Thanks

        Raj