I have a column that represents a warehouse location like 1PA22AA, which 1 represents the floor, PA represents the corridor, 22 is the location inside the corridor and AA the shelf.
I have separated between different columns the floor and the corridor (PA in this case) and it is all that matters for me.
I need to group a bunch of corridors to a condition like if the floor is 1 and the corridors goes from AA to BA (AA, AB, AC, ... BA) is zone 1, and so on.
How can I write an if function without have to specify all the corridors like AA, AB, AC, and so on?
@jmsm Not sure what kind of source you have. But is it possible to create a reference/lookup table with all possible combinations and join it here. to get the required outcome.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!