How to filter that showing items when the last two digits of the value is 90 or 99?

[Anonymous]

Hi,

I want to create a filter that could show the items when the last two digits of the value is 90 or 99. I am not sure how to create via DAX.

Could you please help?

Thanks!

[pranit828 · Accepted solution]

HI @Anonymous 

Create a new column as below and use it as filter

_90_99 = 
IF(RIGHT('Table'[Column],2) in {'90,'99'}, "90_99", "Others")

[Anonymous]

Thanks! I did the same a few minutes ago!