Log In
Register
Home
June 24, 2020
Offline
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!
Moderators
January 31, 2022
Offline
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
October 5, 2010
Offline
You can also use the IN operator when you want to use OR logic.
= CALCULATE(
sum([amount]),
FILTER(
'AP-RAW',
[Hosp / Pharma] IN {"Pharma" , "Hosp."} && [TRANSACTION_TYPE_NAME]=earlier([TRANSACTION_TYPE_NAME]) && [DESCRIPTION]=EARLIER([DESCRIPTION]
)
)
)
Regards
Phil
1 Guest(s)
