Forum Discussion
Fill data for Missing Dates and Hours
In the attached set of data: FYI: All those data should be continuos one. For better visualiztion, I split. For July 1, 2nd-5th hour data is missing And for July 2nd, 6th-15th hour data is miss...
You could use GENERATESERIES with LOOKUPVALUE function. Basically Generate (1-24) values for a given Data, Add a calculated column with an IF Statement that will Lookup that values from the Dates table that you have, and if the result is BLANK() put 0 in Then Condition of the IF Statement.