Hi @Bobmoran ,
From your description, it sounds like you're looking to count orders expected to be delivered within a specific date range and then break down this count by month.
Please try below steps:
1. Create a Date Table: If you haven't already, create a Date table that includes all dates that could possibly fall within your order delivery windows. This table should span beyond your current order dates to accommodate future orders. Make sure this table is marked as a Date table in Power BI.
2. Establish Relationships: Ensure there's a relationship between your Date table and your Orders table. Typically, this would be a relationship between the Date column in your Date table and the delivery date columns in your Orders table.
3. Create a Measure: You'll need to create a DAX measure to count the orders expected to be delivered each month. Here's an example measure that might work for you:
OrdersCountPerMonth =
CALCULATE(
COUNTROWS('Orders'),
FILTER(
'Date',
'Date'[Date] >= MIN('Orders'[StartDate]) && 'Date'[Date] <= MAX('Orders'[EndDate])
)
)
This measure counts the rows in your Orders table where the date falls between the StartDate and EndDate of the orders.
4. Visualize the Data: Use this measure in a visual, such as a bar chart or matrix. Drag the month column from your Date table to the Axis area and the OrdersCountPerMonth measure to the Values area.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
