Power query - cross join - net discounted cash flow

michiel_soede

New Member
Joined
Oct 7, 2009
Messages
12
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
 
Last edited:

Forum statistics

Threads
1,077,776
Messages
5,336,183
Members
399,069
Latest member
haxahid

Some videos you may like

This Week's Hot Topics

Top