Forum Discussion
Missing dates with one criteria.
Hello community, I didn't found a similar topic in this forum to help me so I'm creating this one. I'm new to powerquery and I'm struggling with fusion and jointure types to find and fill missin...
Created a solution with some dummy data similar to yours.
Does this work for you?
All dates (from 21st to 26th for all names)
You can download the excel file (power query solution) here
Hope it helps
Yep I tried this already but it seems to work when you have only one name for example. As I have many names powerBi has to understand that for each name no date is mssing (kind of loop I guess?)
parry2k
Super User
Super UserAnonymous not sure what you mean by one name. Can you share more details and how you are doing it?
By name I mean the column "Name" in my example. If you have only name "A" then it works to merge this table with the date table. As I have name "A" and "B" and so on then the query has to cmpare all dates from names "A" & "B" to all dates in the dates table.