Replicating an Excel table with calculated cells

Hi Anonymous ,

Sorry for the late response. In my solution in order to prevent to have 3 querys (2 for the inputs and 1 for the merging) I made a single one with two different sources and then on a later step I merge the queries.

You can do it with different tables on your model and several queries no problem. I also created the weeks table in order to simplify my tough process you can do it in any source way you want it, from the excel file, a DB source or a direct input on the PBIX file.

The only steps that are important on this way of setting up things is the grouping, unpivot and the merging of the tables. the sources are multiple.

Regarding the advance coding you don't need it as refer prior you can make the merge from existing tables.

The last step is where imake the final calculation you can add steps after that removing or adding additional information.

Regards,

Mfelix