Calculate Monthly Growth that would respond to slicers for specific months.

[Anonymous]

Hi Team,

I need help with mu current logic for monthly growth:

Call Count Monthly Growth =
Var PrevMonth = CALCULATE(SUM('Table'[CallCount]),PARALLELPERIOD('Table'[ReportMonth],-1,MONTH))
Var ThisMonth = CALCULATE(SUM('Table'[CallCount]))
return DIVIDE((ThisMonth - PrevMonth), PrevMonth)

For this current logic, this wouldn't respond to slicers for a selected month. It only works for the previous month.

What I want is for the slicers would respond if I only select 2 months for example: January and April

I want to compare the growth rate for both months ONLY. So I want i to calculate the growth for those specific months.

[SpartaBI · Accepted solution]

@Anonymous  there is a pattern for that by the amazing SQLBI.
Check out this video and article:
https://www.youtube.com/watch?v=JBN-x2duxSU
https://www.sqlbi.com/articles/comparing-with-previous-selected-time-period-in-dax/

In case this is the answer for your question please mark this as a solution for community visibility

[Anonymous]

Thank you for this! This works!

However, it only works when using a table.

It doesn't work when I use a line chart (graph).

Can anyone help?

[Anonymous]

Hi @Anonymous ,

The reason for this is that the measure at this point is a scalar and only shows continuous lines when there are multiple monthly slices.

You can also choose some custom visuals, such as this one.

It will display the rate of change of the quantity on the top of the graph as well.

Attached PBIX file for reference.

Best Regards,

Gao
Community Support Team 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hello!

I forgot to update that the video posted actually works. I just forgot to apply a certain network because we want the data to be internal only.

However, do you or anyone know how this could work for weekly growth?

[SpartaBI]

@Anonymous so please accept that comment with the video links as a solution to help other members find it more easily.
Regarding weekly growth there isn't a specific video for that, rather you need to combine the knowledge you gained from that video + apply it to a weekly custom column.
Check out these pattern for weekly calendars:
https://www.daxpatterns.com/week-related-calculations/

Don't forget to mark all the relvant comments as solutions