Create new table with row for every day

[johankent30]

I have the following table and am trying to create a new table which takes in the min and max date from the Date Value column and does not skip any days. The issue is that when I disply this data in a matrix, days that have no data are not shown. I want the days to show even if they don't have any collections data. The ideal result would be to create a new table that was identical to this one but for days with no data had a row for every possible combination of category, subcategory, and Date Type. The Custom.cust_num can be blank for those days. Is this possible? Thanks!

[v-lili6-msft · Accepted solution]

hi, @johankent30 

You could try this way:

Use this formula to create a date table and then create the relatonship with basic table

Date=CALENDAR(MIN('Table' [Date Value]),MAX('Table' [Date Value]))

Now use date field from date table.

You could enable Show items with no data in Power BI  in the visual.

Best Regards,

Lin

[Anonymous]

Johan,

Check this out, I think it's what you want:

https://community.powerbi.com/t5/Desktop/Add-rows-missing-date-values/td-p/118463

cheers,

glenn