Forum Discussion
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...
Hi,
Yeah it is possible, you just need to add MAX's iteratively. E.g.
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
Community Champion
Community ChampionHi,
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)
Is it possible to use the same for multiple columns, which is more than 4?
Thank you!
Megha
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