Forum Discussion
question on DAX
Hi BPI users, I have a question on Dax, I have column contains 7 product names and I want to create a Y/N column where Y = all the 7 product names and N = include all except one product name . ...
Anonymous
Do you want to use this in the filter or calculation?
could you pls provide the sample data and expected output?
I want to use that in a filter
the total products I have is
My expected output for Y is all the 7 products together and N should have all the 6 products except the one which is left out.
Anonymous
pls see the attachment to check if this is what you want