
Nawaf H H AlTaher
Riyadh, Saudi Arabia
Member
Members

Forum Posts: 17
Member Since:
June 24, 2020
June 24, 2020

Hello friends, Hope all is well!
Please help me with the below DAX formula.
Trying to have the OR function applied. So if the field has either the word "Pharma" or "Hosp." then resume.
the below formula needs editing please.
= CALCULATE(sum([amount]), FILTER( 'AP-RAW',[Hosp / Pharma]="Pharma"&&[Hosp / Pharma]="Hosp."&&[TRANSACTION_TYPE_NAME]=earlier([TRANSACTION_TYPE_NAME])&&[DESCRIPTION]=EARLIER([DESCRIPTION])))
Thank you so much in advance!

Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 440
Member Since:
January 31, 2022
January 31, 2022

Can't test it but the && logical operator equals an AND. Since you seem to need an OR, use || (a double pipe).
More on that in the link below.
https://learn.microsoft.com/en.....-reference
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Michelle Neven
Andrew Kuhn
Angela Paul
Forum Stats:
Groups: 3
Forums: 24
Topics: 6206
Posts: 27202
Member Stats:
Guest Posters: 49
Members: 31875
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
