Forum Discussion
Comparing Two Month Column Values, then Arrow Conditional Formatting Based On Comparison
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 .
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
1 Reply
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