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?
sorry tamerj I did not know you were in the midst of helping!
Don't misunderstand me. Am not trying to book this post snd never tried to book any other post. This is an open platform where everyone has the absolute right to participate in any post.
Back to this post, I was looking into this through my phone and started wondering why the MAX between the columns did not work while it siply should.
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 otherMAX only allow 2 arguments
