Forum Discussion
Solved
Power Query Merge Question
Hello All, Suppose I have two files PQ1 and PQ2 and data in PQ1 and PQ2 are as follows: Legal Name Deal Origination Date Maturity Date TMT D351 3/31/2016 3/31/2023 Deal ...
Cmpunk Can't judge how the logic could be altered without seeing some real data. Many transformations in PQ can be done by just clicking the correct buttons, but at some point in time you'll find yourself needing to write or edit M-code in order to achieve more complicated goals. So, it's inevitable that you have to start learning about it.
Thanks Riny for your solution. I have one doubt when you added custom column and wrote following M-code: Table.AddColumn(#"Added Index", "OD2", each if [Maturity Date] <> [Extended Maturity Date] then [Origination Date] else #"Filled Down"[Maturity Date]{[Index]-1})
I am not familiar with M-language yet? Is there any other way to implement this logic?
Thank you for your response.
I am not familiar with M-language yet? Is there any other way to implement this logic?
Thank you for your response.
Cmpunk Can't judge how the logic could be altered without seeing some real data. Many transformations in PQ can be done by just clicking the correct buttons, but at some point in time you'll find yourself needing to write or edit M-code in order to achieve more complicated goals. So, it's inevitable that you have to start learning about it.