Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query Editor M Code to fill as duplicate rows between dates

So my data in query editor is structured as such:   What's the best way to add rows to this table that are duplicated between each date. For example, the 1st row shown should be duplicated an...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi  Anonymous ,

     

     

    Check this file as example: Download PBIX 

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Can you explain what are you trying to achieve ? I didn't get the logic for it.

 

Ricardo

Anonymous's avatar
Anonymous
Not applicable
6 years ago

camargos88

The below is an example of the result for the first row.

 

 

 

This would be replicated for each row of the original table with the additional rows being the dates between.