Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Comparing values to previous months

Hi,   I am wondering whether it is possible to achieve this and display as a table. I have a table that displays client number by month. I then want to add new measures that calculates the d...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jennratten,

 

I have tried your method and still not getting the result i want. I have created a new date table from the link you have provided and then created a new measure below:

 

Users PM =
var CurrentYearMonthNumber = SELECTEDVALUE('HP Date'[Year Month Number])
var PreviousYearMonthNumber = CurrentYearMonthNumber -1
var Result =
    CALCULATE(
        Measuretbl[CountuserV1],
        REMOVEFILTERS('HP Date'),
        'HP Date'[Year Month Number]=PreviousYearMonthNumber
    )
return
    Result
 
This is giving me the figure for previous month but i want to display my table as my screensnip. I want to show the numbers by month up to the current month. Then within the same table after the current month, show the difference in numbers to previous month, since Apr 22, 6 months ago and 12 months ago.
 
Do i need to add a new measure that calculates the difference? also what objects do i show in my table?
 
Not sure if i have understood your answer clearly so would be grateful if you can provide an example of how you set out your table
 
My table is set out as below:
 
 

 

SUG, calendarMonths.DisplayPeriod objects are from my data table
CountUserV1 is from my measurestable (distinctcount of User IDs)
Users PM is my new measure i have created and linked to my Date Table
 
kind regards
 
Hetal
jennratten's avatar
jennratten
Icon for Super User rankSuper User
3 years ago

In order to have all of this shown on one table, you will need to either create measures for all of the values to be included in the table or create a calculated table that produces the desired results and then add all to the visual.  Calculations should be dynamic so you won't have to update them for specific dates, like CurrentValue-1Mo, CurrentValue-2Mo, CurrentValue-3Mo, ChangeVs12Mo, ChangeVs6Mo, etc.  

Please let me know if I can further assist.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Just to confirm, do you mean i would need to create measures for each month, Apr, May, Jun etc as well as diff to Apr, diff to previous months, 6 months and 12 months?

     

    Are you able to give me an example?

     

    kind regards

     

    Hetal

    • jennratten's avatar
      jennratten
      Icon for Super User rankSuper User
      3 years ago

      Please see the attached sample file.  You would not need to create a measure for every month; just for the relative month.


       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you very much for this.