Forum Discussion
Help on Finding Matches In One Column Only
My table is currently set up as below.
I need to match only the codes (if they match - there maybe a Code for Product A but not for B and Vice Versa) in which case it would leave a blank on the row for the Product which isnt in this example but it will be the case)
I would like the final result like this(ignore the colouring)
2 Replies
lennox25 , Pivot Product column in Power Query, and then you can have column
if [A] <> null && [B] <> null then "True" else false
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
or create measures like
A= calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "A") )
B= calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "B") )
Result = if(isblank([A]) || isblank([B]) , False(), true() )
Use them in visual with other group bys
HI amitchandak I know how to Pivot and have Pivoted but the column is not working its syntax error?
