Hi @Sergei Baklan sir,

I have invoice detail table as below:

Also, I have EM – Misc Charge table that don’t have date column:

But these 2 tables have ‘DBName-Point_Id’ , ‘DBName-Id’ & ‘Charge’ as a common columns.

I need to find the dates for each rows of ‘EM – Misc Charge’ table from invoice detail table for their corresponding ‘DBName-Point_Id’ , ‘DBName-Id’ & charge using power query transformations(upstream).

I am struggling to achieve this. we had a idea of appending these tables but that would increase the number of rows as we have millions of rows in our original data. This may cause a performance issue.

PFA file here Budget vs Accruals.pbix

Please let me know if you need further details

Thanks in advance!

​Hi @Sergei Baklan sir, I have invoice detail table as below: Also, I have EM – Misc Charge table that don’t have date column: But these 2 tables have ‘DBName-Point_Id’ , ‘DBName-Id’ & ‘Charge’ as a common columns.I need to find the dates for each rows of ‘EM – Misc Charge’ table from invoice detail table for their corresponding ‘DBName-Point_Id’ , ‘DBName-Id’ & charge using power query transformations(upstream). I am struggling to achieve this. we had a idea of appending these tables but that would increase the number of rows as we have millions of rows in our original data. This may cause a performance issue. PFA file here Budget vs Accruals.pbixPlease let me know if you need further details Thanks in advance!   Read More

​