Forum Discussion

CCalloway's avatar
CCalloway
Regular Visitor
7 years ago

Month over Month Variance

HI,

Im asking for help or tip on how add a measure that woud calculate the "GSV" variance from each month using the example below? Example I want to calculate and show the variance from Jan 2017 compared to Jan 2018 and then  Jan 2018 to Jan 2019.

 

 

 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    CCalloway you can use parallelperiod or dateadd functions to do these kind of calculation. There are tons of blogs/post on this.