Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi lbendlin,

I am not sure how to add these transformation steps to a calculated table. I am new user of Power BI. Could you please let me know. I think these steps can only be added in Query editor.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Yes, in Power Query add a blank source, then open its Advanced Editor and replace the code there with what I posted.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    I don't know how to do it in DAX without a UNIONX function.