Results 1 to 1 of 1

Thread: Power query - cross join - net discounted cash flow
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2009
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Power query - cross join - net discounted cash flow

    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,

    Last edited by michiel_soede; Oct 18th, 2018 at 02:56 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts