topic Re: count number of lines and separate them into two columns in DAX Commands and Tips

count number of lines and separate them into two columns

Anonymous — Sun, 04 Jun 2023 17:11:52 GMT

Hii, I'm new to powerbi. For the below table, for each cutomer Id, I want to split the "Alerts" column into two columns based on position of the line. The odd ones should get stored into Alerts1 and even ones into Alerts2. I'm not able to do this. Can anyone help me with this. Thank you.

Re: count number of lines and separate them into two columns

wdx223_Daniel — Mon, 05 Jun 2023 00:39:47 GMT

=Table.SplitColumn(PreviousStepName,"Alers",each List.Transform(List.Zip(List.Split(Text.Split(_,"#(lf)"),2)),eacth Text.Combine(_,"#(lf)"),{"Alerts1","Alerts2"})

Re: count number of lines and separate them into two columns

Anonymous — Mon, 05 Jun 2023 04:49:41 GMT

Hii, Thanks for your reply. After applying this formula, I'm getting this below error.
Expression.Error: 3 arguments were passed to a function which expects 2.
Details:
Pattern=
Arguments=[List]
Can you please tell me why it is coming? Thank you

Re: count number of lines and separate them into two columns

wdx223_Daniel — Mon, 05 Jun 2023 05:43:50 GMT

=Table.SplitColumn(PreviousStepName,"Alers",each List.Transform(List.Zip(List.Split(Text.Split(_,"#(lf)"),2)),each Text.Combine(_,"#(lf)")),{"Alerts1","Alerts2"})

Re: count number of lines and separate them into two columns

Anonymous — Mon, 05 Jun 2023 06:31:26 GMT

Thank you so much. It worked.