Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX(Using MAXX)

Hi All, This is the data I have created in PowerBI. Screenshot is given below:     I have the data in the same format in excel. The screenshot is given below:     Based on the abov...
Help appreciated
Help Requested
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    Yeah it is possible, you just need to add MAX's iteratively. E.g.

     



ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

It is possible to do this kind of comparion by using nested MAX() functions, but I wouldn't recommend it. Instead you can unpivot the data in PQ. 

Multiselect columns with shift click and press the arrow:


Then unpivot columns. Also you can add an index column to keep track of the groups created this way.

In my Example I have 4 columns and index column.
Start data:

 


After unpivot I have this kind of data:


Dax:

Max with if = IF(MAX('MAX'[Value])>7,7,MAX('MAX'[Value])+1)

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ValtteriN ,

 

Thank you for your reply!

 

Its not pivoted to unpivot.

 

And all the columns are calculated columns which is created by me.

 

I need to implement that formula on the calculated columns in PowerBI.

Can I please know how to do that?

 

Thank you!
Megha

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    If you want to do this with a calculated column you need to use nested MAX functions e.g.

    Column =
    var _max = max(MAX('MAX'[Column1],'MAX'[Column2]),max('MAX'[Column3],'MAX'[Column4])) return
    if(
    _max>7,7,_max+1)
     
     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Is it possible to use the same for multiple columns, which is more than 4?

       

      Thank you!

      Megha

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi ValtteriN,

       

      Could you please tell if it is possible to use the same for multiple columns, which is more than 4?

       

      Thank you!

      Megha

      • ValtteriN's avatar
        ValtteriN
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Hi,

        Yeah it is possible, you just need to add MAX's iteratively. E.g.