Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
If my Dimension entity has structured with code concatenated with name, for example, "B1101 - Roof", but i would like to hide code when i use it in Axis to show only "Roof". How could I do it?
Solved! Go to Solution.
Create a new column in PBI that will return the Provision division name and replace provision division with the new column.
Product Division Name = RIGHT(Table1[Product Division],LEN(Table1[Product Division])-FIND("- ",Table1[Product Division]))
Hope this helps.
Thank You khader312
But if i connect data from CUBE live connect, which i cannot create new column or new measure?
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |