The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a dataset where I want to be able to select a timeframe and pull a list of customers.
I want to filter another list of customers based on the first timeframe.
I brought in the dataset and created a slicer to narrow down the data. I then created a new table with the same dataset as the first but with a different date slicer. I am looking for a way to say not in or to filter the second dataset from the first.
EX: I want to know what customers made an order in November but did not make an order in September or October.
Hi,
Share some data and show the expected result.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
105 | |
97 | |
55 | |
48 | |
48 |