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...
Greg_Deckler
Community Champion
Community ChampionPossibly. ImkeF might have an M solution. Only thing I can think of in DAX would be to use a GENERATESERIES, for example and generate hours 0-23. Then you could use that table and your original table to create a new table that included the missing rows. Sample data that can be compied would be great.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- ImkeF
If you create a table with rows 1-24 and merge that on JoinKind.FullOuter with your original tables, you'll get one row for each hour.
Then create a new conditional column that returns 0 if your "old" column "Hour" is null and if not, return "Value" instead.
