Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating custom Column based on multiple conditions and comparison

Hello there ,   I am looking for help, how can we create a dax expression based on multiple condition and comparison ? , below is the scenario which i wish to obtain, so for example we have data a...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

We can create a calculated column using the formula to meet your requirement.

 

excepted col =
VAR maxdate =
    CALCULATE (
        MAX ( Table1[Date] ),
        FILTER ( ALL ( Table1 ), Table1[ID] = EARLIER ( Table1[ID] ) )
    )
RETURN
    IF (
        Table1[Date] = maxdate
            && Table1[Satisfaction] = "NOT SATISFIED",
        1,
        BLANK ()
    )



For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/y3b8yxaurvsjkpo/Creating%20custom%20Column%20based%20on%20multiple%20conditions%20and%20comparison.pbix?dl=0

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you very very much for your help v-frfei-msft, this worked just great,
i am also having one another issue calculating the cumulative average, but thats a another question on discussion, still i am posting that link, please see if you can help me figure that out as well, 

 

link: 

https://community.powerbi.com/t5/Desktop/Calculating-Cumulative-total-of-average-using-DAX-expression/m-p/508842#M237710

Much thanks v-frfei-msft

 

Regards,

Malav