Forum Discussion

Magpie_Rob's avatar
Magpie_Rob
Icon for Helper I rankHelper I
5 years ago
Solved

SUM when date > dynamic date

Hello,    I'm trying to perform a dynamic calculation. the premis is I want to see when a customer first used a promotional code, and how much the have spent with us after.  I have calculated ...
Need Help
  • VijayP's avatar
    VijayP
    5 years ago

    Magpie_Rob 

    CALCULATE(amt,Filter(all(DAtedim),datesdim(date)>mcd))

    You  need to created  Date Table to connect to the fact table to achieve above

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

Magpie_Rob 

CALCULATE(amt,Filter(all(DAtedim),datesdim(date)>mcd))

You  need to created  Date Table to connect to the fact table to achieve above