Forum Discussion

Vick143's avatar
Vick143
Frequent Visitor
3 years ago
Solved

Calculated column with conditions

Hi, I am trying to create a new calculated column called Inforce by contract group using the following data sample, I have added that column to showcase expected result. These are the conditions for...
"Calculated Column"
"DAX"
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Vick143 

     

    You can try the following methods.

    Result = 
CALCULATE ( MAX ( 'Table'[Inforce Flag] ),
    FILTER ('Table',
        [Contract Group] = EARLIER ( 'Table'[Contract Group] )
            && [Period] = EARLIER ( 'Table'[Period] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Vick143 

 

You can try the following methods.

Result = 
CALCULATE ( MAX ( 'Table'[Inforce Flag] ),
    FILTER ('Table',
        [Contract Group] = EARLIER ( 'Table'[Contract Group] )
            && [Period] = EARLIER ( 'Table'[Period] )
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.