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

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