Hello, I am still learning Power BI, and need some assistance.
I have a table with multiple dates as shown below:
Order ID |
Order Date |
Pick Date |
Ship Date |
Delivered Date |
Invoice Date |
258 |
30-Oct-19 |
31-Oct-19 |
1-Nov-19 |
10-Nov-19 |
11-Nov-19 |
259 |
12-Nov-19 |
14-Nov-19 |
15-Nov-19 |
23-Nov-19 |
25-Nov-19 |
260 |
15-Nov-19 |
17-Nov-19 |
18-Nov-19 |
26-Nov-19 |
28-Nov-19 |
261 |
1-Dec-19 |
3-Dec-19 |
4-Dec-19 |
12-Dec-19 |
14-Dec-19 |
262 |
10-Dec-19 |
12-Dec-19 |
13-Dec-19 |
21-Dec-19 |
23-Dec-19 |
263 |
17-Dec-19 |
19-Dec-19 |
20-Dec-19 |
28-Dec-19 |
30-Dec-19 |
264 |
23-Dec-19 |
25-Dec-19 |
26-Dec-19 |
3-Jan-20 |
5-Jan-20 |
I want my users to select one date range, which would be used to calculate number of Orders received, Order on route, Orders delivered, and Orders Invoiced.
I have created a dates table as shown below:
Dates =
VAR BaseCalendar = CALENDARAUTO(6)
RETURN
GENERATE(BaseCalendar, VAR BaseDate = [Date]
VAR YearDate = YEAR(BaseDate)
VAR MonthNumber = MONTH(BaseDate)
RETURN ROW(
"Day", BaseDate,
"Year", YearDate,
"Month Number", MonthNumber,
"Month", FORMAT(BaseDate,"mmm"),
"Year Month", FORMAT(BaseDate, "mmm yy")))
and provided Users with Date Slicer.
My problem is I don't know how to link the date slicer to my Orders Table to provide me with the count of Orders received, Orders on route, Orders delivered, and Orders Invoiced based on user selected dates
Can someone Help.
------------------------------
Mebs
------------------------------