Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

added missing rows to table

i have a  table with date and count in Power Query. after the starting date, each week has a new count.   for this table for some weeks count and date are missing.(ex: March 6th,march 20th,Ap...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You could create a table with below formula.

New_Table = 
var _calendar = CALENDAR(MIN('Table'[start of week]),MAX('Table'[start of week]))
return
ADDCOLUMNS(_calendar,"count",LOOKUPVALUE('Table'[count],'Table'[start of week],[Date])+0)

 

Best Regards,

Jay