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.
in power bi desktop go to EDIT QUERIES
in the query editor right click the Fruits colunm and select split colunm
in the menue select split by delimiter
in the pop up select the following Custom from teh drop down
in the box provided enter +
Split at "Each occurrense of the Delimiter
Click Advanced options
select split into Rows
and in Qoute Charated select None
Click Okay and your data source shoult now be as requested
Proud to be a Super User!
in power bi desktop go to EDIT QUERIES
in the query editor right click the Fruits colunm and select split colunm
in the menue select split by delimiter
in the pop up select the following Custom from teh drop down
in the box provided enter +
Split at "Each occurrense of the Delimiter
Click Advanced options
select split into Rows
and in Qoute Charated select None
Click Okay and your data source shoult now be as requested
Proud to be a Super User!
@Anonymous
From the Query Editor, add this custom column, then expand it to new rows
=Text.Split([Fruits Purchase],"+")
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 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |