Forum Discussion
jmelizalde
4 years agoNew Member
Max in column
I have 6 columns with difernts dates, this reprecents diferents activityes for the same proyect what i want is create a column that calulate the Max of this diferent Columns The funtion Max doesnt w...
- 4 years ago
Hi:
I'm pretty sure you need to unpivot here as MAX won't take more than a couple of columns.
Please review my solution for this instance.
Whitewater100
4 years agoSolution Sage
High:
If you go to transform data and click on just the player column and under transfor you can look for unpivot columns and choose Unpivot Other Columns. It should like this after that operation;
Then the measure is easy:
High Date = MAX(HighDate[Value])
Whitewater100
4 years agoSolution Sage
Hi:
I'm pretty sure you need to unpivot here as MAX won't take more than a couple of columns.
Please review my solution for this instance.