Forum Discussion
How to find the rows with missing date range
Hi Everyone, We get the Bills from clients every month, but the Bill start date and Bill end dates are not constatnly the same. I would like to find the invoices missing between these dates. The c...
The data set I posted on this query is not a real one. There are other columns with Start date, end date all coming from summarised calculated table in PBI desktop. So , I need to perform operation on this calculated table. Is there any ways, I can get this calculated table from desktop to Query editor where I can perform those actions.
Or in the code you have attached, is it possible to change the data source to calculated table ?
lbendlin
Super User
Super UserI don't know how to do it in DAX without a UNIONX function.