Forum Discussion
Cumulative Count and Empty Column
Hey everyone, I was trying to build a rolling cumulative count column chart on PowerBI. And the count is weekly basis (each column represents the total number of rows in the table before that wee...
If there is no data to include, you cannot in DAX. You need to add through Power Query or the source system values of 0 for the missing week.
If the weeks exist in your fact table but are blank or null in Power Query, replace with 0 before loading.
If you have a date table from Power Query, you could create an anti-join on your data table and date table, keeping only dates/weeks that don't exist in your data, then append it to the bottom of your table with $0 value.