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...
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,