Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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.
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.