Forum Discussion
Sam7
Advocate II
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 w...
Sam7Advocate II
Advocate IIHi. 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
Super User
Super UserPlease 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!