How to identify a service number that is associated with two service names?

[ritar_li]

Hello, 

I'm trying to identify service # that includs two service names A AND B. My table is

Service	Service#
A	1
B	1
A	2
A	5
A	3
B	3
B	4

I'm a new user to Power BI. If this question is duplication of previous post(s). Please direct me to right track. I appreciate your help ahead.  

Hong

[amitchandak · Accepted solution]

@ritar_li , A new column

new column =

var _1= calculate(distinctcount(Table[Service]), filter(Table, [Service#] =earlier([Service#]) && [Service] in {"A", "B"}))

return

if(isblank(_1), false(), true())

[ritar_li]

Hi, dear supper user, 

I have a new issue just came out related to question above. My company just dropped off the service B after 9/1/2021. As a result, the vales in colume after 9/1/2021 turn in False. I have problem to fomulate a calculation to experess this time point change. I greatly appreciate your help. 

Hong