Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
184
Views
Topic starter
Hi All,
I am very new to Power BI and need help in following...
I am running a query based on answer in this thread to copy rows based on a condition...
let
CN = [#"Column4"]
in
if Text.Length(CN)=11 and Value.Is(Text.Start(CN,4),type text) and Value.Is(Number.FromText(Text.End(CN,7)),type number)
then List.Repeat({CN},13)
else {CN}
But its checking this condition in only one column i.e. Column4 while I want it to check condition on Column3, Column4 and Column5. Any help please?
Posted : 22/08/2020 7:36 am
Hi Sajid,
Please attach your workbook so we don't have to recreate your data.
Regards
Phil
Posted : 23/08/2020 12:33 am
