multiple ifs with multiple conditions

[ggalstyan]

Hello everyone,

I am trying to solve the following issue with multiple ifs and conditions

if eventnumber=eventnumber and unit's(starts with BLS or RA) dispatch time is after unit's dispatch time(starts with E or T), then TRUE, FALSE.

I might bring more variables later, but now need to make these conditons work

Much appreciated!

[newpowerbiuser8]

Hello, I need to add a condition to an already existing formula:

Where Form submitted = 1 AND BOR date = 0 it should calculate days between Form submitted on and today.

IF('PRC Change Management Pipeline List'[Number Form Submitted on]=1,IF('PRC Change Management Pipeline List'[Number BOR updated date number]=1,CALCULATE(COUNTROWS('Calendar'),FILTER('Calendar',WEEKDAY('Calendar'[Date],2)<6),DATESBETWEEN('Calendar'[Date],'PRC Change Management Pipeline List'[Form Submitted on],'PRC Change Management Pipeline List'[BOR updated date]-1))))

Your help will be greatly appreciated 🙂

[amitchandak]

@ggalstyan , Based on what I got

new column =

var _cnt = countx(filter(Table,[eventnumber] = earlier([eventnumber])  && ( left([unit],3) = "BLA" || left([unit],2) = "RA") && [Entry Time] > earlier([Entry Time] ) ),[eventnumber])

return

if(isblank(_cnt), "No", "Yes")

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

[ggalstyan]

@amitchandak 

I got the yes and no but the out come is incorrect, I need more help please

RA/BLS added afterwards =

var _cnt=COUNTX(FILTER(URPT,[EVENTNUMBER]=EARLIER(URPT[EVENTNUMBER]) &&(LEFT(URPT[UNIT],3)="BLS" ||LEFT(URPT[UNIT],2)="RA") &&[DISPATCH].[Date]>EARLIER(URPT[DISPATCH].[Date])),URPT[EVENTNUMBER])

return

IF(ISBLANK(_cnt),"No","Yes")

For the followig I was excpecting yellows to be yes and blue to be no

and for eventnumber 23001414 it should ideally return n/a as there were no RA/BLS added to this call at all.

Thanks

[amitchandak]

@ggalstyan ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ggalstyan]

@amitchandak 

EVENTNUMBER	UNIT	DISPATCH	RA/BLS added afterwards	commnets
23001414	T21	1/6/2023 08:26:26	No RA/BLS
23001413	BLS27	1/6/2023 08:27:20	Yes	as it was added after 08:25:39
23001413	E27	1/6/2023 08:27:14
23001413	BLS26	1/6/2023 08:26:15	Yes	as it was added after 08:25:39
23001413	BLS21	1/6/2023 08:25:39	No	it was right at08:25:39
23001413	T26	1/6/2023 08:25:39
23001412	T26	1/6/2023 08:15:57	No RA/BLS
23001410	BLS29	1/6/2023 08:12:47	Yes	as it was added after 08:12:37
23001410	E29	1/6/2023 08:12:37
23001405	BLS26	1/6/2023 07:31:16	No
23001405	E26	1/6/2023 07:31:16
23001400	BLS22	1/6/2023 06:47:52	No
23001400	E22	1/6/2023 06:47:52

[ggalstyan]

@amitchandak @Thanks I Will try this tomorrow and let you know if works: I believe I understand the concept now.