Question to identify discrepancies

Hi Babycakes_00 ,Thank you for reaching out to Microsoft Fabric Community Forum.

If you want to create a report that shows all customers with the date they placed an order, and you want to be able to filter by a specific date (e.g., 1/7/2024) to see if each customer has placed an order on that date, try this:

1. Let’s assume you have two tables:

(Table1) Customers & (Table2) Orders

Customers: Contains Customer ID, Customer Name, Address, etc.

Orders: Contains Customer ID, Order Date, Product, Quantity, etc.

2. Ensure there's a relationship between the Customer ID in the Customers table and the Customer ID in the Orders table. If not, create a relationship.
3. You might want to have a dedicated date table to help with filtering. If you don’t have one, create a Date table:

DateTable = CALENDAR(MIN(Orders[Date]), MAX(Orders[Date]))

4. Make sure you relate this Date table to the Orders table using the Order Date.
5. let's create a measure that will check whether a customer has placed an order on the selected date.

Order on Selected Date =

VAR SelectedDate = SELECTEDVALUE(DateTable[Date])

VAR CustomerOrder =

    CALCULATE(

        MAX(Orders[Date]),

        Orders[Date] = SelectedDate

    )

RETURN

    IF(ISBLANK(CustomerOrder), BLANK(), CustomerOrder)

6. Add a Table visual report to your visual.
7. Add Customer Id, Customer Name & the measure to the fields of table visual.
8. Add a Date slicer to filter by the date you want. When you select a specific date, the table will update to show All customers, The order date for those who placed an order on that date, The order date for those who placed an order on that date.
9. Your output will be something like this:

If you think this post helps, please mark it as Accept as Solution, so others with similar queries may find it more easily.