Add missing days using PQ

@Naila,

It’s often a best practice in Power BI to add a date dimension to your model, especially when dealing with time-based analyses like cumulative calculations over time. The date dimension ensures you’ll have a continuous date range, even when your data do not include records for every single date. This will solve your issue of “gaps” in your cumulative line.

Take a look at eDNA Extended Date Table.

1 Like