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

Anonymous — Wed, 08 Jun 2022 12:03:14 GMT

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 .

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

Anonymous — Mon, 13 Jun 2022 07:03:07 GMT

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

topic Re: Comparing Two Month Column Values, then Arrow Conditional Formatting Based On Comparison in DAX Commands and Tips

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

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