Need urgent help. How i can achieve this in Power bi

[Adeelmushtaq]

I have data like below 

ID Status

1 Requested

1 Approved

2 Requested

3 Requested

1 Closed

3 Approved

i want to add one more column which will add a bit 0/1 in front of each row if that id is approved. like below

ID Status isApproved

1 Requested YES

1 Approved YES

2 Requested NO

3 Requested YES

1 Closed YES

4 Requested NO

3 Approved YES

Please help. using DAX.

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works

=if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Status]="Approved"))>0,"Yes","No")

Hope this helps.

[camargos88]

@Adeelmushtaq ,

What logic you want to apply on this new column ?

[Adeelmushtaq]

I want to apply the logice that if id 1 is having approved entry then mark this new column as yes. same for each id.

[PhilipTreacy]

Hi @Adeelmushtaq 

That's not clear.  You have ID's where the Status is not Approved, but they have Yes?

Phil