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

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

    VijayP  you are a genius and a gentleman, thank you very much

    Result = CALCULATE(SUM ( 'report v_fct_sales_order_promo_customers'[sales_order_item_total_amount]), FILTER(datetable,DateTable[Date] > [MCD] )  )
    • VijayP's avatar
      VijayP
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Magpie_Rob You are Welcome, I Appreciated your Kudos by pressing 👍Icong. Thanks