Forum Discussion
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 work because this is a calulation for date in a column not data between columns.
also im traing with variable and conditional code but still not success.
is there oter funtion than can Help me
is Excel should be like that
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.
9 Replies
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 other
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])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.
