Forum Discussion
convert Line Break Values
Hi how to convert Line Break Values from One Cell to Multiple rows in power bi, i have a imported excel there is an 3 cilumn has line break values first column is has Text, second has date, thisrd has number + hypen Please find the below onedrive link in which i have shared excel file, i wish to saperate line break cell and convert into row for below column.
Results should be like below
Sum of Rent = $ 750,562,274
Sum of RENT2 = $ 753,108,337
i wish to convert/split them in to row and the data visuals should be reflact on filter selection of the month on visulisation page. i wish to have a table on visulisation page which include data like in wxcel file but it should be replact or change on the selection of monthand display for that month with upcoming expiring product details . Please note sum of rent should not be exceed than in excel. i tried to split column and then i noticed that rent value gets multiple according to rows after splitting any colum
3 Replies
Anonymous what sheet you are referring to in excel ? Is it sheet2? What would be the logic to split the line. Can you provide some example in Excel, it will help to provide the solution.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Sorry for dalay in reply.
Please have a look of the shared data and my earlier threate on community for your reference.
Could you please help me with new table in query editor without disturbing the results sheet values, which i shown in RESULT TAB in excel by Month
also
i wish to see the results in which month which poduct is newly added and and stopped producing and in another month it get re start production and it's count based on sample data Month | New | Closed table should be like this
Please help me
