topic Re: Max in column in DAX Commands and Tips

Max in column

jmelizalde — Tue, 15 Mar 2022 17:10:28 GMT

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

Re: Max in column

tamerj1 — Tue, 15 Mar 2022 17:38:37 GMT

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?

Re: Max in column

Whitewater100 — Tue, 15 Mar 2022 17:48:36 GMT

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])

Re: Max in column

Whitewater100 — Tue, 15 Mar 2022 17:50:06 GMT

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

Re: Max in column

jmelizalde — Tue, 15 Mar 2022 17:57:42 GMT

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

Re: Max in column

tamerj1 — Tue, 15 Mar 2022 18:01:45 GMT

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.

Re: Max in column

tamerj1 — Tue, 15 Mar 2022 18:07:43 GMT

Hi jmelizalde

the code should simply be

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

Re: Max in column

jmelizalde — Tue, 15 Mar 2022 19:17:51 GMT

MAX only allow 2 arguments

Re: Max in column

Whitewater100 — Tue, 15 Mar 2022 20:17:25 GMT

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.

Re: Max in column

tamerj1 — Wed, 16 Mar 2022 03:43:17 GMT

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