Forum Discussion
Help with new column
I need to create an extra column in my table that populates the reason code which is 81 into the Type 1 New column, seems very straight forward but can anyone help
| Booking ID | type | Reason Code | New Column |
| 49265 | 1 | 81 | |
| 49265 | 2 | 81 |
|
Hi mikejmurphy7 ,
Please check if this matches your expected outputif [Reason Code]=null then List.Max(Table.SelectRows(#"Changed Type",each [Booking ID]=[Booking ID])[Reason Code]) else nullBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
2 Replies
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.Hi mikejmurphy7 ,
Please check if this matches your expected outputif [Reason Code]=null then List.Max(Table.SelectRows(#"Changed Type",each [Booking ID]=[Booking ID])[Reason Code]) else nullBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
