Hello @SonaSinghA
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 .
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
