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.
We have a spreadsheet that is exported from a third party regularly. The spreadsheet has too much detail in the field we want to report on in Power BI. For example...
I don't care about the colour! (or the RAM.) How do I edit, in Power BI, that field? This is easy in Excel:- LEFT(A2, FIND("(",A2)-1) results in "iPad Air 2" for all of them, which allows us to count them.
How do I do this in Power BI? I don't want to edit the spreadsheet each time it is created.
Thanks
Solved! Go to Solution.
Hi @TimRattray ,
It seems that you want to edit your data source before create the report in Power BI.
Normally, we could shape and clean the data source in Query Editor.
If I understand your requirement correctly that you want to shape the data below.
If you want to only retrieve the data iPad Air 2, you could use the feature Split column in Query Editor.
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @TimRattray ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample which could reproduce your scenario and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @TimRattray ,
It seems that you want to edit your data source before create the report in Power BI.
Normally, we could shape and clean the data source in Query Editor.
If I understand your requirement correctly that you want to shape the data below.
If you want to only retrieve the data iPad Air 2, you could use the feature Split column in Query Editor.
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |