Highlight Row in Table Based Off Date

[CalebR]

I have a table with all of our transaction history, I have created a table visual by extracting the yearmonth from the TransactionDate and summed the Qtys with a measure. 

My table looks like this 

yearmonth	Usage
2022/04	0
2022/05	0
2022/06	0
2022/07	0
2022/08	0
2022/09	0
2022/10	0
2022/11	0
2022/12	0
2023/01	0
2023/02	0
2023/03	25

I want to highlight the last six months in green like this :

yearmonth	Usage
2022/04	0
2022/05	0
2022/06	0
2022/07	0
2022/08	0
2022/09	0
2022/10	0
2022/11	0
2022/12	0
2023/01	0
2023/02	0
2023/03	25

Ive tried using the cell elements tab and applying a measure to the background color using the "rules" format style but so far it is just returning like this.

Does anyone know any way of doing this? Am I missing something obvious? 

Thank you in advance for any help.

My background formatting 

My last six months measure: 

Last 6 Monthsv2 =

VAR yearmonthtest = SELECTEDVALUE(IM_ItemTransactionHistory[yearmonth])

Return

    IF(  yearmonthtest >= FORMAT(DATE(YEAR(TODAY()), MONTH(TODAY())-6, 1), "yyyy/MM"), 1, 0)

[v-zhangti · Accepted solution]

Hi, @CalebR 

You can try the following methods.

Color Measure = IF(SELECTEDVALUE('Table'[yearmonth])>=EOMONTH(MAXX(ALL('Table'),[yearmonth]),-6)+1,"Green",BLANK())

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[CalebR]

Really weird, it works perfect in your provided pbix file but in my report it just refuses to let me do it. Thank you anyway for your help. Marking this as the solution as it does indeed work just not in my instance for some reason. 

thanks!

[CalebR]

This is precisely what I need but how were you able to select the measure in the formatting pane? Mine will not let it be selected and highlights that box in red instead.