Forum Discussion
Select A subset
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]))
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 |
1 Reply
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?
