Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Good morning, I'm hoping you can help.
In our rental software which includes employees, our locations are named:
In Bamboo, they are named:
Locations will not change but employees and equipment are added daily.
How can I slice the page by location when my location names don't match? Right now, I have 2 slicers but thats not user friendly.
Appreciate any help please. Thank you.
Solved! Go to Solution.
tried removing spaces and it's still not happy:
@wotkara Not sure I have all the information needed for a full solution but seems like you could always just add a conditional/calculated column that converts the names. In DAX, a simple SWITCH statement would suffice.
Thank you Greg for your reply. I have looked further into your reply and found this helpful solution:
Solved: Is there a way to use SWITCH with CONTAINS? - Microsoft Fabric Community
However, I am receiving an error message when trying to duplicate it. Will you explain the error to me so I can fix? Thank you.
Yes both sound great but I'm new to this world so do you mind telling me how to do this?
I have 13 tables that use office location "C" "MC" "O" "OKC"
I have 1 table aka Employee that uses "Loving" "Kiowa" "Odessa" "OKC"
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |