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...
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