DAX HELP

[Anonymous]

Hello World,

I want to create some logical functions in Dax. 
I have my dataset from 2016-2022. I have a column Prior Payment Mode and After Payment Mode. Here Prior Payment Mode and After payment mode is a month to month comparison. For example Jan 2017 prior payment mode and Feb 2017 After Payment mode. In this way i have data till Oct 2022. 
I have created another 2 new column i.e. Year and Month. Here, Year and month columns are related to After Payment mode Year and Month. 

Now , my main focus here is 2 mode which is special reversal and problem mode. I want to identify , which prior payment mode they were on before they turn to special reversal and Problem. 

Please help Thank you

[FreemanZ]

hi @Anonymous 

no sure about your exact expecation, if we simplify your data, you may create a new table with this:

Table =

FILTER(

    TableName,

    TableName[After] in {"SpecialReversal", "Problem"}

)

I tried and It worked like this:

the simplified dataset,