Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |