The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Can you help me with DAX query. I have to split the data in a column and group them into same data of the column and and the corresponding values of another column.
Here's an example
Thanks in advance for your help
Solved! Go to Solution.
@Anonymous , In power Query Remove [ and ] and the use split by delimiter into rows and then use group by if needed
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
@Anonymous , In power Query Remove [ and ] and the use split by delimiter into rows and then use group by if needed
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
Thanks amit, I was able to do all the process required in power Query, I was concerned to create a measure for it to be reusable but nonetheless, I accept your advise as solution. Appreciate the prompt reply.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |