Summarize Incremental Data

Hi Khomotjo , hello bhanu_gautam, thank you for your prompt reply!

To resolve your issue, verify the following steps:

• Create a Date Table: You could create a date table that contains all possible dates and link it to your data model. Then, you can use this date table to show all dates.

DateTable = CALENDAR(MIN('Order'[Finalised]), MAX('Order'[Date]))

•  Calculation Measure: Calculate the count of orders based on Finalised Date but make sure that for missing dates, you return a 0. Here's a possible DAX solution using a date table:

FinalisedCount = COALESCE(
CALCULATE(
    COUNTROWS('Order'),
    FILTER(
        'Order',
        TRUNC('Order'[Finalised]) = TRUNC(MAX(DateTable[Date]))
    )
),0)
​

Result for your reference:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.