Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX HELP

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

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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,