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
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
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.
