Daily monitoring (Calendar date)
Hi All, I'm preparing a dashboard for daily monitoring on the invoice payment based on the invoice due date. Here is samply of my data: Notes: Status are compare with today date (11/10/2023) Invoice No Net Due Date Status PLSMAUS020027981 11/6/2023 Pass Due PLSMAUS020027981 11/7/2023 Pass Due US10009470 11/8/2023 Pass Due CBNP02JAN23 11/9/2023 Pass Due AC0303MAR23 11/10/2023 Today Due CBNP02JAN23 11/11/2023 Not Due AC0303MAR23 11/12/2023 Not Due CBNP02JAN23 11/13/2023 Not Due AC0303MAR23 11/14/2023 Not Due CBNP02JAN23 11/15/2023 Not Due AC0303MAR23 11/16/2023 Not Due CBNP02JAN23 11/17/2023 Not Due I want to display the cumulative status for daily monitoring. Example for date 11/10/2023, there will be data for pass due (4), today due (1), Not due (7). I create new table for calendar and link with invoice table (due date). However, its give me the chart like this: I want the chart to be like this 11/10/2023 11/11/2023 11/12/2023 11/13/2023 11/14/2023 11/15/2023 11/16/2023 11/17/2023 11/18/2023 11/19/2023 11/20/2023 11/21/2023 Pass Due 0 1 2 1 4 2 6 4 1 3 5 8 Today Due 1 1 1 1 1 1 1 1 1 1 1 1 Not Due 11 10 9 8 7 6 5 4 3 2 1 0 Can anyone assist me how to create the DAX and what the tips to make it possible. Thank you.
