Forum Discussion
ulyssus
3 years agoRegular Visitor
Help - lookup value
Hi All, I am new to power bi and couldn't figure this query out. I have a table like below with the list of work email based on the source. Name Work email Source Dave [email protected] A ...
ulyssus
3 years agoRegular Visitor
Hi, Thanks for the response. I was able to transform the data from rows to columns. now I need to check if the email in column b & C matches with column A. if so, i would like to return the same value (it should ignore the blanks as it comes up as "not matched").