Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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!
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.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |