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.
Hi,
Needing assistance to categories IDs by service combinations:
With thanks,
Solved! Go to Solution.
Hi,
I was able to resolve my query by using the measure on this post:
Thanks for the quick response. Not sure if I understand the measure provided.
The Service Name is actually a string and I need to identify if the string contains the text: standard or high, to then have the ability to roll up and categorized this at the ID level.
Hi @bbwong,
Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi,
I was able to resolve my query by using the measure on this post:
You can create a column in the query editor that just has Standard, High, etc. (text after delimiter of "= " for example), and then use a measure like this.
NewMeasure = CONCATENATEX(DISTINCT(Table[ServiceName]), Table[ServiceName], "/")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |