cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zibster Helper II
Helper II

New Column MAX

Hi,

 

I am trying to add a column that would identifie Max date place "CY" if the date = to max and place "CY" for others, here is my short code that i get error on.

= Table.AddColumn(#"Changed Type", "CyLy", each If(List.Max(#"Changed Type"[txn_dte])=[txn_dte],"CY","LY"))

 

Thanks

Z

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: New Column MAX

@zibster 

 

Add a custom column as below.

 

= if [Txn_dte] = List.Max(#"Changed Type"[Txn_dte]) then "CY" else "LY"

 

 

image.png

 

 

Edit: Remember to append previous step name to the column. In my case, "Changed Type" is the previous step and i am referring the date column as List.Max(#"Changed Type"[Txn_dte]) instead of List.Max([Txn_dte])

 

If it helps, mark it as a solution

Kudos are nice too

View solution in original post

4 REPLIES 4
Super User I
Super User I

Re: New Column MAX

@zibster 

 

Please provide sample data  with expected output to answer the questions correctly.

zibster Helper II
Helper II

Re: New Column MAX

Please see below

 

image.png

 

 

 

Super User I
Super User I

Re: New Column MAX

@zibster 

 

Add a custom column as below.

 

= if [Txn_dte] = List.Max(#"Changed Type"[Txn_dte]) then "CY" else "LY"

 

 

image.png

 

 

Edit: Remember to append previous step name to the column. In my case, "Changed Type" is the previous step and i am referring the date column as List.Max(#"Changed Type"[Txn_dte]) instead of List.Max([Txn_dte])

 

If it helps, mark it as a solution

Kudos are nice too

View solution in original post

zibster Helper II
Helper II

Re: New Column MAX

Thanks 

 It works perfect 🙂

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors