Forum Discussion
First value from another column
Hi everyone,
I have to calculate a new column/measure that for each client it will take first from a different column. For instance, how to calculate City_new? Is it possible?
| Customer ID | City | City_new |
| 1 | Warsaw | Warsaw |
| 1 | Paris | Warsaw |
| 1 | London | Warsaw |
| 2 | Moscow | Moscow |
| 2 | Riga | Moscow |
| 3 | Vienna | Vienna |
| 3 | Warsaw | Vienna |
| 3 | London | Vienna |
| 3 | Lisbona | Vienna |
Best Regards!
Hey Anonymous ,
you can add a calculated column and use the following formula:
City_new = CALCULATE( MAX( myTable[City] ), ALLEXCEPT( myTable, myTable[CustomerID] ) )Be aware that this will just give you the last value from an alphabetical point of view. In general there is no order in the Power BI data. So ID 1 and Warsaw could in other circumstances appear as second row.
If you want to have a specific element as first, you have to add a column with the order of the cities.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
1 Reply
Hey Anonymous ,
you can add a calculated column and use the following formula:
City_new = CALCULATE( MAX( myTable[City] ), ALLEXCEPT( myTable, myTable[CustomerID] ) )Be aware that this will just give you the last value from an alphabetical point of view. In general there is no order in the Power BI data. So ID 1 and Warsaw could in other circumstances appear as second row.
If you want to have a specific element as first, you have to add a column with the order of the cities.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic