Max in column

[jmelizalde]

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

[Whitewater100]

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 · Accepted solution]

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.

[tamerj1]

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?

[jmelizalde]

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

[tamerj1]

Hi @jmelizalde 

the code should simply be 

MAX ( table[column1], table[column2], etc. )

[jmelizalde]

MAX only allow 2 arguments

[tamerj1]

@jmelizalde 
You are absolutely right. I feel so stupid 🙂
No worries while @Whitewater100 is in town. He never misses.
Have a great day!

[Whitewater100]

sorry tamerj I did not know you were in the midst of helping!

[tamerj1]

@Whitewater100 

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.