Forum Discussion
johankent30
Helper I
Helper ICreate 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...
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
v-lili6-msft
Community Support
Community Supporthi, 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