Hello,
How can get below output in Power BI.
If blank then WS, rest based on input data
Regards,
How can get below output in Power BI.
If blank then WS, rest based on input data
interline working_12Mar23 (version 1).xlsb | ||||
---|---|---|---|---|
U | V | |||
12 | Input | Output | ||
13 | AB8195~CD9597 | AB CD | ||
14 | ~**5362 | ** | ||
15 | ~AB0875 | AB | ||
16 | BF0816~ | BF | ||
17 | **5774~**5362 | ** ** | ||
18 | **5774~HM0135 | ** HM | ||
19 | WS | |||
20 | HM0128~**5027 | HM ** | ||
Sheet2 |
Regards,