Forum Discussion

DGTL's avatar
DGTL
Icon for Helper I rankHelper I
5 years ago

DAX Calculate delay per month

  Hello, Can you unlock me on a Dax measure? I would like to have a monthly bar chart with a calculation of overdue orders each month. Example: The customer requests a delivery for the 02/01/202...
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Another option upon Table Dates:

overdueOrders2 = 
var currentDate2 = SELECTEDVALUE('Table Dates'[Date])
var RES2 = 
CALCULATE(
    COUNTROWS(Overdue_orders),
    FILTER(
        Overdue_orders,
        currentDate2 >= Overdue_orders[Requested date] &&
        currentDate2 <= Overdue_orders[Delivered date]))

Return
IF(ISBLANK(RES2),0,RES2)