Forum Discussion
Fill empty dates in series
Hi, I currently have a dataset [date,type,quantity] I'm loading it into a line chart. Date are in "date" format, but I have some "jumps" on the dataset (using some types) as in: 05/01 - 05/02 - 05/...
Anonymous,
Add relationship to the calendar table.
v-chuncz-msft
Community Support
Community SupportAnonymous,
Drag date from a calendar table and add an appropriate measure.
Table = CALENDAR ( MIN ( Table1[date] ), MAX ( Table1[date] ) )
Measure = SUM ( Table1[quantity] ) + 0
Hi! I had a calendar table, still not sure how to use it to fill empty dates on my data table1[value,date].
Thank you!
- v-chuncz-msft
Anonymous,
Add relationship to the calendar table.