Forum Discussion
Max in column
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.
Hi jmelizalde
can please explain more why MAX did not work? What code did you try? Are you trying to create a measure or a calculated column?
Im try to create a calculet column comparind the data of other 6 columns with date and i want to know the lasted date and put in the new calulate columns, as i show in the Excel example.
Im creating a cycle time report with start proyect date and i want the date of the last activity compled thats why i need a caluclated colunm with the MAX value of 6 column of the same record
This is just one of the differents ways that i already try to get this column, asign variable to the column then with some conditional function to evaluete each one versus the other
MAX only allow 2 arguments
jmelizalde
You are absolutely right. I feel so stupid 🙂
No worries while Whitewater100 is in town. He never misses.
Have a great day!