If status is Approved, display 0 If status is not approved , display no.of days waiting for pending

[Amarreddyetcs]

Hi All,

Kindly help me on below query.

 Result:-

Date	Site	Status	No.of days waiting
		Approved	22
		Pending from Approval	33
		Pending from Approval	33
		Pending from Approval	33
		Approved	24

Expected Result:- 

Date	Site	Status	No.of days waiting
		Approved	0
		Pending from Approval	33
		Pending from Approval	33
		Pending from Approval	33
		Approved	0

already created two columns in power BI visual 

1) Status = if (ISBLANK(Table1[Column1]),"Pending from Approver",  

If (Table1[Column1]) = "New", "Approved")) 

Note:-(Status column was displaying result like  "New" and Balnk values , so written above formula )

2)

No.of_Days wating = DATEDIFF(Table1[Date],TODAY(),DAY)

Could plz help out If status is Approved, No.of days waiting level should display 0(Zero) only.

Thanks for Advance.

[Greg_Deckler · Accepted solution]

@Amarreddyetcs As a column:

No.of_Days wating = IF([Status] = "Approved", 0, DATEDIFF(Table1[Date],TODAY(),DAY))

[Amarreddyetcs]

Thank so much Sir given quick solution.. @Greg_Deckler