Forum Discussion

danb's avatar
danb
Resolver I
8 years ago
Solved

% Change over Time

Hi Everyone! I am struggling to figure out how to build a matrix visual that will show me a weighted average % change of spend over time. I have an example of where my data is at as well as what I wo...
Need Help
  • danb's avatar
    danb
    8 years ago

    After some more research, I was able to solve it by creating two measures.

     

    1. Value First Date = CALCULATE([Extended Spend running total in Date],CALCULATETABLE(FIRSTDATE('Table1'[Date]),ALLSELECTED('Table1'[Date])))

     

    2. Time Period Driver = DIVIDE(sum('Table1'[Extended Spend]),[Value First Date])*1

     

    I then dropped in the "Time Period Driver" measure into the matrix visual and it worked. 

Tenzin's avatar
Tenzin
Frequent Visitor
3 years ago

I know this is a stupid question, but how do you  get the extended spend running total?  Can you post the dax formula? Thank you.