Calculate Growth Current Month Vs Month YA

[Anonymous]

Hi,

I'm trying to see some growth numbers comparing this months year vs last months year. These aren't values so I'm using COUNT:

To get values for the previous year, I created this measure:

However, it doesn't seem to work. Does anyone know what I'm doing wrong? 

My end goal is to have the growth numbers displayed by month

Thanks!

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous,

For each month in the bar chart, the filter context only contains dates of currently month.

So add REMOVEFILTERS() to your measure. Or some other functions like ALL(), ALLEXCEPT(), ALLSELECTED().

processed report last month =
CALCULATE(
    [processed report this month],
    PREVIOUSMONTH( 'Table'[Date] ),
    REMOVEFILTERS()
)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,

PARARRELPERIOD with the settings you have returns the value from last month. To get LY you can use e.g. PREVIOUSYEAR. e.g. CALCULATE([Measure],SAMEPERIODPREVIOUSYEAR('Calendar'[Date])).

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

Hi,

Thank you. It looks like I'm getting values which is great but the values are exactly the same:

Would you know what I'm doing wrong here? 

[ValtteriN]

Hi,

Are you using date column from your calendar in your visualization? Also what kind of relationship do you have between your calendar and fact table?

[Anonymous]

Hi, I'm using my month name from my data table

Here is the relationship between both tables