Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Use calculate to work out previous years instance

Hi,

 

I am wanting to use a variance against the previous year but I am unable to do same period last year as I am going of a custom column called instance rather an a date.

 

The instance is the instance of the Monday in the month so for example comparing the first instance of Monday Ujly against the first Monday of July last year.

 

So I am wanting to have a variance column comparing for example 2017 to 2016.

 

Need Help

9 Replies

  • Abduvali's avatar
    Abduvali
    Icon for Skilled Sharer rankSkilled Sharer
    9 years ago

    Hi Anonymous,

     

    My understanding you trying to see the difference in sales between this year and the last year. I have replicated what you have you can find it in my library by clicking on the link below:

     

    Hope that helps.

     

    Regards

    Abduvali

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Abduvali,

       

      Thanks for that, unfortunatly not what I am loking for.

       

      I need to find a way to use the item selected from the slicer in a measure to calculate the sales against the previous year but what has been selected in the slicer.

       

      Thanks

       

      C

  • Abduvali's avatar
    Abduvali
    Icon for Skilled Sharer rankSkilled Sharer
    9 years ago

    Anonymous

     

    I think if you just create a new measure with following calculation (2016 Total - 2017 Total) to what you already have and you will get your variance column, and you can filter by anything you want it will do the calculation for you.