Forum Discussion
Help with formula
Hi ,
A member of the forum, kindly provided me the following forumla:Column = IF(ISERROR(FIND(LEFT([Transaction Number],FIND("-",[Transaction Number])-1),[Line Description])),0,1)
However , how do I update it to look in all of the rows of column:Line Description? The issue I have is the the value in column:Transaction Number maybe on a different row in column:Line Description.
Thank you in advance.
4 Replies
craig811 Please provide some sample test data and expected output to provide an accurate solution.
Thank you for the reply :
Please see the below:
As you can see W1173778 is in colunm 'Line Description' but on a different row then colunm' Transaction Number' . The formula above will not pick this up and will show '0' instead of '1' for match.
Could I use the 'Earlier' function with the IF statement to look and the entire column for a match instead of looking at just the current row?
craig811 ,
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/DAX-search-in-column-and-retuen-a-result/m-p/572635#M270471
