Forum Discussion
Adding mulitple rows into one from datattype html to create a "Summary of operations"
I am trying to createa powerquery BI, where I have many reports, and from the reports (they are html format), I am trying create an "Example of table" so powerBI knows which parameters to take in. From there, there is section with many subsection (hour by hour) for operations. I wish to add all of thouse however into one cell in the PowerBI as a "Summary of Operations". How can I do this? I cant seem to find out how
2 Replies
If they are in different columns, you can simply concatenate using the & operator. If they are in lists, List.Combine, List.Zip, or List.Union may work. But we need to see data to help.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Hi, fahaint
May I ask if your problem has been solved? Is the above post helpful to you?
If it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
