Solved: Another If statement

therugger2000 · ‎10-07-2022

I am attempting extract text from a column based on another column.

Basically if the value from column1 =1, return the first 3 characters in Column 2, if not return rthe first 2.

Example of Column1 info : 1 or 2

Column2 Info: 1234abcd

new=IF Column1="1", LEFT(table1[column2],3, LEFT(table1[column2],2

Any help is appreciated.

AnkitKukreja · ‎10-07-2022

Hi! @therugger2000

Please use the below m code and it should work for you.

Col1 Col2 Extraction

1	123abs	123
2	145grbf	14
3	345	34
1	111ggg	111
2	2334	23
1	2332mmm	233
2	233mmm	23

if [Col1] = 1 then Text.Middle ([Col2],0,3)
else
Text.Middle ([Col2],0,2)

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja/

View solution in original post

AnkitKukreja · ‎10-07-2022

Hi! @therugger2000

Please use the below m code and it should work for you.

Col1 Col2 Extraction

1	123abs	123
2	145grbf	14
3	345	34
1	111ggg	111
2	2334	23
1	2332mmm	233
2	233mmm	23

if [Col1] = 1 then Text.Middle ([Col2],0,3)
else
Text.Middle ([Col2],0,2)

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja/