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.
I have a problem I cant seem to solve with my limited DAX knowledge.
I am trying to increase the IN_COUNT values of some specific locations in this table in a new column
I want to increase the IN_COUNT according to the percentages in the table below (But only the locations that match with the locations in the first Table above) All the other locations in the first picture that are not in this table need to keep their original IN_COUNT value.
So the new column should show a new IN_COUNT value if the locations are the same, if the location is not in the second table the new IN_COUNT should stay the same as before.
I have tried some DAX formulas but cant seem to find a solution to do this.
Solved! Go to Solution.
Hi @Anonymous ,
Try using LOOKUPVALUE() Lookup I would break this into two columns, so that you are comfortable with what you are doing, and then after combine the two formulas into 1. First use LOOKUPVALUE () to search the other table for the name of the city based on the test column and the value it is looking up is the city in your first table. Return a zero perhaps if not found. Then the if looks at that column and if there is a city name, get the value from the other table, else keep the value from your first table.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Try using LOOKUPVALUE() Lookup I would break this into two columns, so that you are comfortable with what you are doing, and then after combine the two formulas into 1. First use LOOKUPVALUE () to search the other table for the name of the city based on the test column and the value it is looking up is the city in your first table. Return a zero perhaps if not found. Then the if looks at that column and if there is a city name, get the value from the other table, else keep the value from your first table.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |