Forum Discussion

johankent30's avatar
johankent30
Icon for Helper I rankHelper I
7 years ago
Solved

Create new table with row for every day

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!

 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

     

2 Replies