Hi,
I'm relatively new to Power BI, so I'm hoping there is an easy solution to this request.
I have a set of 5 similar tables - each table is for a specific product, and will have at least the following columns
- Order Request Received Date (this is the date we recieved the request from client)
- Order#
- Order Create Date (the date when the order was created based on request from client)
- Current Order Status (In Progress/Completed/Canceled)
- Order Completed Date (the date when order was completed)
(there are other columns too, but some of those will vary between the 5 tables)
I need to build a summary visualization (preferably a single one that has data for all 5 tables, but if not, we can live with 5 separate visualizations), that shows the following
- Week Ending date
- Number of requests received (In table, look for records that have "Order Request Received Date" for that week ending)
- Number of orders issued (In table, look for records that have "Order Create Date" for that week ending)
- Number of orders completed (In table, look for records that have "Order Completed Date" for that week ending)
- Number of orders in progress (In table, look for records that have ("Order Create Date" <= "Week Ending Date", and "Order Completed Date" >="Week Ending Date" minus 7 calendar days) <-- this logic may need to be tweaked, but it can be done.
The question:
If I needed to get the count of orders issued, I can just create a matrix visualation that would count number of records by the week/ending of order create date. But given that I want the same visualization to show the count of orders completed in that week, how do I go about creating that (since the count of number of records now has to look at week/ending for order completion date)?
