Hi,
I am not sure if it is possbile in Power BI, however is there a way I can match the following:
Colunm A has : W345678-New
Colunm B has : 45635 | W345678
As the value 'W345678' exists in both colunms, I want to remove the rows from my report. All the vlaues I want to match are in the same format as above Colunm A values have -New after each value and Colunm B has a value then |.
Many thanks
Solved! Go to Solution.
Hi @craig811
You may try below measure:
Column = IF(ISERROR(FIND(LEFT([ColumnA],FIND("-",[ColumnA])-1),[ColumnB])),0,1)
Regards,
Cherie
Column = IF(FIND(LEFT([ColumnA],FIND("-",[ColumnA])-1),[ColumnB]),1,0)
Thank you,
However I get the following error:'The search Text provided to function 'FIND' could not be found in the given text' any idea how to fix it?
Make sure that the first 2 column references are the same. Also does all your data in column A have a "-" before the "new"?
Try putting a default value in if you don't find the hyphen.
Column = IF(FIND(LEFT([ColumnA],FIND("-",[ColumnA],1,"999999")-1),[ColumnB]),1,0)
Thank you for the reply,
Yes, I do have some data in ColumnA that does not have - and some rows are blank.
Hi @craig811
Could you show some data with screenshot?
Regards,
Cherie
Thank you,
Please see screenshot attached.
Hi @craig811
You may try below measure:
Column = IF(ISERROR(FIND(LEFT([ColumnA],FIND("-",[ColumnA])-1),[ColumnB])),0,1)
Regards,
Cherie
Thank you for solution,
However, how do I get the if statament to look in all the rows of columnB ([Line Description) to find a matching value with colunmA:
Great thanks Cherie,
This might be a silly question, however how do I get the formula to look for the value in columnA and if it exists in column B then enter value 1?
For example:
ColumnA ColumnB
W111234-NEW TEST
71554 | W111234-NEW
So from the above the value in column A exists in column B ,but might be on a different row in column B. I would still like it to show a value of 1 in the new column.
Hope that makes sense.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
216 | |
57 | |
49 | |
46 | |
45 |
User | Count |
---|---|
267 | |
211 | |
113 | |
82 | |
71 |