Inserting rows for missed days

[chopper2585]

Hello, I have an issue I'm trying to work through where we have a large list of customers, with numerous accounds, shells, and groups, then have values for each hour of the day, for 7 days. 

However, some customer-account-shell-group combinations dont necessarily have all 7 days accounted for, but we need those missing days to display in our matrix so we can call out that all 24 hours of that day are missing.

Here is how the data currently looks:

You can see some are missing days randomly. The same can happen within the same customer-account-shell combination, where they have 4 different groups each missing a different day.

This is what I need the data to look like in PowerBI:

I have a separate table in PowerBI with the DayKey and Day text for all 7 days, but I can not find a way to insert those missing days for all different record groupings.

Here is a link to the data shown in the screenshots above.

I'd love to see some suggestions for how this can be done. Thank you for any help you can provide!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[chopper2585]

Thanks so much Ashish! This worked perfectly

[Ashish_Mathur]

You are welcome.