First value from another column

[Anonymous]

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!

[selimovd · Accepted solution]

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 regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic