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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Magpie_Rob ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.