fiberboysa
Board Regular
- Joined
- Apr 25, 2012
- Messages
- 106
- Office Version
- 365
- Platform
- Windows
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...
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?
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...
Power Query:
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}