michiel_soede
New Member
- Joined
- Oct 7, 2009
- Messages
- 15
Dear all,
Question. I have a table with contract start dates and contract end dates. I want to cross join this in power query with a table containing all months from 1/1/2019 to 31/12/2039 which are potentially the months in which payments can be done under the contracts.
Is there a way in which I can limit the cross join to only the periods that fall in the specific contracts? So for example if one contract runs from jan-19 to dec-25 I only want those months to be expanded in the cross join and not other months which are not lying that contract period. Obviously this can vary per contract.
A related question would be if I need to calculate for many contracts (15k x multiple items per contract x the number of periods that fall in the contract) the discounted cash flows under the contract how quick is such an operation via powerquery? I don't have a good feeling about how quick power query is with handling such large operations if I will built something in powerquery.
Thanks in advance,
Michiel
Question. I have a table with contract start dates and contract end dates. I want to cross join this in power query with a table containing all months from 1/1/2019 to 31/12/2039 which are potentially the months in which payments can be done under the contracts.
Is there a way in which I can limit the cross join to only the periods that fall in the specific contracts? So for example if one contract runs from jan-19 to dec-25 I only want those months to be expanded in the cross join and not other months which are not lying that contract period. Obviously this can vary per contract.
A related question would be if I need to calculate for many contracts (15k x multiple items per contract x the number of periods that fall in the contract) the discounted cash flows under the contract how quick is such an operation via powerquery? I don't have a good feeling about how quick power query is with handling such large operations if I will built something in powerquery.
Thanks in advance,
Michiel
Last edited: