Add rows with missing dates in Power Query

Hello Anonymous 

create a dimdate  ( you can from here ) https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query

then in power query, select the attendance table , and merge it with the dimdate . 

choose the join type to be left join to dimdate . ( this way you get everything in dimdate that does not exist in your table ) . 

1 --> your table

2--> dimdate table 

3-->  right join 

let me know if it works for you . 

NB (  you need to join with dimdate table having only dates for today's date so that you only return the dates missing until todays an not until end of year 2024 ) so maybe the dimdate created needs some minor tweaking . 

If this answers your question  ,  mark it as the solution ✅ so can you can help  other people in the community find it easily . 

Can you please share your demo input and expected output!

pls try this