Forum Discussion
Advocate IIDax Data appears twice
My data looks like
I want to write a measure to say if my
Invoice number appears in week 1 and 2 then week 1 and 2 ,
Invoice number appears in week 1 and not 2 then week 1 and not 2
I want to then use this as a slicer.
Thanks
3 Replies
sevenhillsSuper User
You posted sample data! What is the output you are expecting?
You are saying you want to use the slicer, which you can drag the invoice number with your data now also. Unless you want a unique list. Then in such cases, you can either do in Power Query a new table and link back or in DAX as new table as Values ('Table'[Invoice Number]) and then use it. I prefer Power Query!
Sam7Hi. thank you for your input.
I wanted a slicer so they can select the In week 2 and Week 3 OR another option in the slicer would be In Week 2 and Not in Week 3 etc.
I want to see what has come in during week 2.
- sevenhills
Please see these
Apply AND logic: https://www.youtube.com/watch?v=tONOosN1xAs
https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/
https://www.youtube.com/watch?v=X5T4rIZovHk
Apply OR logic: https://www.youtube.com/watch?v=l5JX3G5Ntzk
Hope this helps!