topic Re: Maintenance Revenue to exclude ...... in DAX Commands and Tips

Maintenance Revenue to exclude ......

Anonymous — Wed, 14 Apr 2021 18:43:07 GMT

From the code below my goal is to exclude "Grip" and "RH RECURE DATABASE SERVICE" from Maint_Revenue column

This is the slice of code that needs to be updated to exclude Grip and RH RECURE DATABASE SERVICE

I have applied "||" as the logical operator to create an OR condition which may not be right.

What's would be the best way to write this code.

"Maint_Revenue", IF(NOT(LEFT(Contract_Items[QT Package],4)="Grip" || "RH RECURE DATABASE SERVICE"), Contract_Items[Price Monthly], 0),

Re: Maintenance Revenue to exclude ......

dedelman_clng — Wed, 14 Apr 2021 20:52:24 GMT

Hi Anonymous -

Try this

Maint_Revenue = IF ( NOT ( LEFT ( Contract_Items[QT Package], 4 ) = "Grip" ) && NOT ( Contract_Items[QT Package] = "RH RECURE DATABASE SERVICE" ), Contract_Items[Price Monthly], 0 )

Hope this helps

David

Re: Maintenance Revenue to exclude ......

Anonymous — Wed, 14 Apr 2021 22:32:55 GMT

Thanks David. It was very helpful.