Select A subset

[Khomotjo]

Hello  Everyone,

I am struggling to do the following in  Power BI :

For a given date:

• Filter all data with a date less than the current date by a day or 2 days if the Date is a Monday;
• Count all orders that  are open.

I tried this :

Today Orders =
VAR Current = TRUNC(MAX(Orders[Date]))

RETURN

 CALCULATE(

    COUNT(Orders[Reference]),

    FILTER(Orders,TRUNC(Orders[Required Date])=TRUNC(Current+1) && Orders[Status] <> "Departed")

)

Below is a view of what my data looks like for 2 dates:

Reference	Status	Product Count	Line Units	Created Time	Finalised Date	Required Date	Movement Date	Analysis Date	Date	Previous_Day	Exports
1	Departed	1	2	03 Feb 25	23 Feb 25	24 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
2	Departed	1	2	03 Feb 25	23 Feb 25	24 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
3	Departed	1	2	03 Feb 25	23 Feb 25	24 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
4	Departed	1	2	03 Feb 25	23 Feb 25	24 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
5	Departed	1	2	03 Feb 25	23 Feb 25	24 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
6	Departed	1	2	03 Feb 25	23 Feb 25	03 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
7	Departed	1	2	03 Feb 25	23 Feb 25	03 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
8	Departed	1	2	03 Feb 25	23 Feb 25	03 Feb 25	23 Feb 25	24 Feb 25	24 Feb 25	23 Feb 25	National
9	Departed	1	2	03 Feb 25	24 Feb 25	27 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
10	Departed	1	2	03 Feb 25	24 Feb 25	28 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
11	Departed	1	2	03 Feb 25	24 Feb 25	03 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
12	Departed	1	2	03 Feb 25	24 Feb 25	03 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
13	Departed	1	2	03 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
14	Departed	1	2	03 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
15	Departed	1	2	03 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
16	Departed	1	2	03 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
17	Departed	1	2	04 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National
18	Departed	1	2	05 Feb 25	24 Feb 25	25 Feb 25	24 Feb 25	25 Feb 25	25 Feb 25	24 Feb 25	National

[ryan_mayu]

Is this a table visual or your raw data? if it's a table visual, pls provide some raw data and what's the expected output based on the sample data you provided?