Forum Discussion

Sam7's avatar
Sam7
Advocate II
2 years ago

Dax 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...
Need Help
sevenhills's avatar
sevenhills
Super User
2 years ago

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!

 

 

 

 

Sam7's avatar
Sam7
Advocate II
2 years ago

Hi. 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.