Forum Discussion
Solved
Counting between two dates but returns blank and the query won't refresh
I have a problem that requires some help. I've loaded data from Excel into Power Query and I'm counting the number of records between two dates which is no problem but when there's no records in the...
Do as it says - provide unique values without gaps on the one side of the one-to-many relationship. That's how star/snowflake schemas are supposed to work. You can't have null/blank as keys.
Ashish_Mathur
Super User
Super UserHi,
Is there a reason that you are trying to solve it in the Query Editor. Would you be OK with a DAX solution? if yes, then share some data to work with and show the expected result.