topic Re: Increasing Specific Values in DAX Commands and Tips

Increasing Specific Values

Anonymous — Thu, 26 Sep 2019 14:23:44 GMT

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.

Re: Increasing Specific Values

Nathaniel_C — Thu, 26 Sep 2019 16:01:05 GMT

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