Creating custom Column based on multiple conditions and comparison

Question

Hello there ,&nbsp;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 as below:&nbsp;IDDateSatisfactionExpectedColumn11/1/2018SATISFIED&nbsp;11/31/2018NOT SATISFIED122/10/2018SATISFIED&nbsp;23/20/2018NOT SATISFIED&nbsp;24/19/2018SATISFIED&nbsp;32/10/2018SATISFIED&nbsp;44/19/2018SATISFIED&nbsp;45/20/2018SATISFIED&nbsp;46/21/2018NOT SATISFIED156/22/2018SATISFIED&nbsp;58/23/2018NOT SATISFIED168/30/2018NOT SATISFIED179/7/2018SATISFIED&nbsp;&nbsp;I have three columns in my Data that are ID, DATE and SATISFACTION, what i am trying to get is 4th "Expected Column" which will be calculated in this way,lets say for ID 1, if the Value in SATISFACTION column is "NOT SATISFIED" for the Latest date in date column, then expected Column should display 1.As we can see in ID 1, ID 4, ID 5, ID 6.&nbsp;kindly help me out on this one please,&nbsp;Thank you,Regards,Malav

v-frfei-msft · Accepted Answer

Hi&nbsp;Anonymous,&nbsp;We can create a calculated column using the formula to meet your requirement.&nbsp;excepted col =
VAR maxdate =
    CALCULATE (
        MAX ( Table1[Date] ),
        FILTER ( ALL ( Table1 ), Table1[ID] = EARLIER ( Table1[ID] ) )
    )
RETURN
    IF (
        Table1[Date] = maxdate
            &amp;&amp; Table1[Satisfaction] = "NOT SATISFIED",
        1,
        BLANK ()
    )For more details, please check the pbix as attached.&nbsp;https://www.dropbox.com/s/y3b8yxaurvsjkpo/Creating%20custom%20Column%20based%20on%20multiple%20conditions%20and%20comparison.pbix?dl=0&nbsp;Regards,Frank

Forum Discussion

Creating custom Column based on multiple conditions and comparison

2 Replies

Related content

Comparison Chart

BI Tools Comparison

Create comparison on same data source

Create conditional measure

Comparison Table

ID	Date	Satisfaction	ExpectedColumn
1	1/1/2018	SATISFIED
1	1/31/2018	NOT SATISFIED	1
2	2/10/2018	SATISFIED
2	3/20/2018	NOT SATISFIED
2	4/19/2018	SATISFIED
3	2/10/2018	SATISFIED
4	4/19/2018	SATISFIED
4	5/20/2018	SATISFIED
4	6/21/2018	NOT SATISFIED	1
5	6/22/2018	SATISFIED
5	8/23/2018	NOT SATISFIED	1
6	8/30/2018	NOT SATISFIED	1
7	9/7/2018	SATISFIED