Highlight increase

[Mahadevaraobc]

Hi all,
Not sure if this is possible, i would like to highlight percentage increase by month.
Eg.
I have a table where column has month and products are in row
I would like highlight in red the value if value is greater than 10% when compared to this month vs last month.

[MattAllington]

Yes it is possible, but you haven’t provided any detail. So, you need to 

1. Write a measure for this month

2. Write a measure for last month

3. Write measures for chg and %chg vs last month

4. Apply conditional formatting on your result based on the % chg measure. 

[Mahadevaraobc]

Thanks for replying Matt, so what measure do I need to write for this month n last month?

[MattAllington · Accepted solution]

Well, that depends on your data. 

You need a calendar table https://exceleratorbi.com.au/power-pivot-calendar-tables/

and time intelligence calcs. https://exceleratorbi.com.au/dax-time-intelligence-beginners/

Typically

total = sum(table[column])

total last month = calculate([total],dateadd(calendar[date],-1,year)

chg = [total] - [total last month]

% chg = divide([chg],[total last month])

---

[Mahadevaraobc]

Can I use the above formula for multiple months

[MattAllington]

Yes, it is a generic formula that works for any month.  If you post a sample workbook with some loaded realistic data including a calendar table, I will show you.

[CConsultants1]

This doesnt work. The whole table colors will be changed based on last month data