Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Previous Month data

Hi, 

 

I have a series of Web data, broken down by week, and I'm hoping to pull in Month-on Month card visualisations for the different variables (bounce rate, uniques etc.) 

 

I have a seperate date table, and also a 'working date column' in my data which groups into months. 

 

 

I've tried a few different methods to get a month-on-month change, or even just a column which show previous month's data, but can't do either. Eg: a column with previous month/change % for bounce rate, another for UVs etc. 

 

is anyone able to help?

 

hopefully this makes sense! 

 

Sonia

 

Need Help
Tips and Tricks

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi Anonymous

     

    Create a calculated measure that SUM's the column you are interested in.  Note this relies on you having a Dates table with a relationship to your base table.

     

    Sum of Unique Visitors = SUM('table'[Unique Visitors])

    Then create a previous month calc using something like

     

    CALCULATE(
        [Sum of Unique Vistors],
        PREVIOUSMONTH('Dates'[Date])
        )
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Phil_Seamark.

       

      Thank you for your help! 

       

      Unfortunatly this returned a blank column for me...  any ideas??

       

       

      I've created a relationship between the 'week' column in my data and the 'date' column in my date table....

       

      Thanks again, 

      Sonia