Forum Discussion

STF29's avatar
STF29
Regular Visitor
5 years ago
Solved

cumulative sum based on a variable data range

Hi Everyone,   I need a dax function that provides a cumulative sum based on a variable range of dates.   I have a table with details of the Contract: N contract Customer Start date ...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    STF29 , your question is interesting and here's a tricky solution.

    Convert your contract table to the following form for the purpose of filtering in DAX,

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

STF29 , your question is interesting and here's a tricky solution.

Convert your contract table to the following form for the purpose of filtering in DAX,

  • STF29's avatar
    STF29
    Regular Visitor
    5 years ago

    Hi CNENFRNL, thank you for your quick support!

    Could you please suggest a way to convert the contract table to the format that you proposed?

     

    Many thanks

    • CNENFRNL's avatar
      CNENFRNL
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hi, STF29 , in the attachment of my preceding reply, you might want to go through all applied steps of convesion in detail in Power Query.

      • STF29's avatar
        STF29
        Regular Visitor
        5 years ago

        CNENFRNL , thank you! Solved!