Toronto Power BI, Power Apps, Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only

How to link Date Slicer to Orders Table with Mulitple dates

  • 1.  How to link Date Slicer to Orders Table with Mulitple dates

    Posted Dec 23, 2019 02:01 PM
    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
    ------------------------------