DAX Multi conditions

[countryfan_nt]

Hello! please help me fix the below DAX formula,

=IF(COUNTROWS(FILTER('PATIENT COUNT - RAW DATA - per Dr',[PatientID]=EARLIER('PATIENT COUNT - RAW DATA - per Dr'[PatientID])&&[Name of Branch]=EARLIER([Name of Branch])&&[InvoiceDate]>EARLIER([InvoiceDate]))),1,0)

I wish to capture ifs:
1. If clinic = ER and for the Earlier Clinic <> ER
2. And for invoice Date is equal or less than Earlier in other clinics (not ER)


Thank you so much in advance

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

DAX Earlier IF formulas / statements

=IF(COUNTROWS(FILTER('PATIENT COUNT - RAW DATA - per Dr',=EARLIER('PATIENT COUNT - RAW DATA - per Dr')&&=EARLIER()&&>EARLIER())),1,0) please help me, I would like to fix the above formula: 1. If clinic = ER and for the Earlier Clinic <> ER 2. And for invoce Date is less...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[countryfan_nt]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

DAX Earlier IF formulas / statements

=IF(COUNTROWS(FILTER('PATIENT COUNT - RAW DATA - per Dr',=EARLIER('PATIENT COUNT - RAW DATA - per Dr')&&=EARLIER()&&>EARLIER())),1,0) please help me, I would like to fix the above formula: 1. If clinic = ER and for the Earlier Clinic <> ER 2. And for invoce Date is less...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

thank you, we are not the same person, but are in the same organization, and are facing the same challenge.

 

[RoryA]

And this? Excel Forum • My Online Training Hub

 

[countryfan_nt]

And this? Excel Forum • My Online Training Hub

Lol that’s mine

 

[RoryA]

And yet you didn't provide the link when asked...

 

[countryfan_nt]

I honestly forgot, is there a way to edit a post?or delete it?

 

[RoryA]

The links are here now, so it's OK. Just remember them in future.