Comparing Two Month Column Values, then Arrow Conditional Formatting Based On Comparison

[Anonymous]

I have three months value in the table  Feb,March,April based on the Attribute Wise . 

please find the screen shot below. i am trying to use conditional formatting for the below table.

• When MARCH MONTH  values are less than FEB MONTH , it will show in conditional formatting Down Arrow.
• When MARCH MONTH  values are Greater than FEB MONTH , it will show in conditional formatting UP Arrow.
• When APRIL MONTH  values are less than MARCH MONTH , it will show in conditional formatting Down Arrow
• When APRIL MONTH  values are Greater than MARCH MONTH , it will show in conditional formatting UP Arrow

Can anyone please advise me on this?  I am looking for support .

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Use Enter data to create a table Month.

2. In Power query. Add Column – Index Column – From 1.

3. Create calculated column.

Month =
FORMAT('Table'[Date],"mmm")

Month_number =
MONTH('Table'[Date])

4. Join the two tables.

5. Create measure.

Measure_true =
var _current1=
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Month_number]=MAX('Table'[Month_number])-1&&'Table'[Group]=MAX('Table'[Group])))
var _current2=
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Month_number]=MAX('Table'[Month_number])&&'Table'[Group]=MAX('Table'[Group])))
return
SWITCH(
    TRUE(),
    _current2>_current1,UNICHAR ( 9650 ),
    _current2<_current1,UNICHAR ( 128315 ),
    _current2=_current1,"=")

6. Result:

Best Regards,

Liu Yang

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