DAX formula help

[EmilyM2019]

Good morning,

I am trying to work out a DAX folrmula to identify if a a certain HR case type is breaching an agreed timescale.  

Below is a sample of my data source.

What I am trying to calculate is:

If 'Organisation' = HCC

And if 'Activity Category' = Investigation

And if 'Count working days' = more than 50

Then I want a "Yes" in my new column, else blank.

Any help would be apprecated.

TIA Emily.

Activity Category	Activity Life Cycle Status (Task)	Changed On (Task)	Ticket ID	Service Category (Ticket ID)	Count working days	Organsiation
Suspension	Open	29-Jan-20	102507883	Misconduct -Child Prot/Safeguarding	4	HCC
Suspension	Open	29-Jan-20	102517066	Managing Misconduct	4	HCC
Suspension	Open	28-Jan-20	102497838	Managing Misconduct	5	HCC
Investigation	Open	05-Dec-19	102145265	Misconduct -Child Prot/Safeguarding	43	HCC
Investigation	Open	27-Nov-19	102101826	Managing Misconduct	49	HC
Suspension	Open	11-Nov-19	102082510	Misconduct -Child Prot/Safeguarding	61	HCC
Suspension	In Process	25-Oct-19	102073521	Managing Misconduct	72	HFRS
Suspension	In Process	26-Jun-19	101717311	Managing Misconduct	159	HC
Suspension	In Process	26-Jun-19	101717628	Managing Misconduct	159	HC
Stage 4	Open	12-Dec-19	102054284	Resolve Workplace Issues	38	HC
Stage 4	Open	05-Jul-19	101412609	Managing Performance	152	HC
Stage 4	Open	16-Apr-19	101643891	Resolve Workplace Issues	210	HFRS

[Jimmy801 · Accepted solution]

Hello @EmilyM2019 

this DAX-formula should work for you

YourNewColumn = if ([Organsiation]="HCC"&& [Activity Category]="Investigation" && [Count working days]>50; "Yes"; blank())

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy 

[EmilyM2019]

Thanks Jimmy, it's the && that I just couldn't get my head around.

Much appreciated.

[Jimmy801]

Hello @EmilyM2019 

thanks for your feedback. It's very appreciated. I'm happy that i was able to help

Jimmy