Forum Discussion
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...
dhruvinushah
Responsive Resident
Responsive ResidentAnonymous Hi,
can you please share the query steps or the M code in the advanced editor being used to understand why the table is not showing rows for the missing weeks?
Thanks !
There is no data for that weeks. but when comes to visualizations using line chart I need to show every week's data even if the weeks have 0 counts. ex: first week's count is 10 and last week's count is 5. line chart adds a line between two weeks. but the correct way is 10 >0>0>5 instead of 10>5