Forum Discussion
salesforce.com filter
I am trying to duplicate a Salesforce.com report within Power BI. The Salesforce.com report has the following filter: Filtered By:1 AND 2 AND 4 and (3 or (5 and 6) or 8) AND 7 1. Company / Acc...
Yes, i am connecting to the object directly using the Salesforce conenctor.
I want to know how to duplicate the same filter in Power BI desktop. How can I get the same filter as the Salesforce.com filter with the brackets ( ) and the AND / OR order of operation. I don't want to import the salesforce filters, i want to know how to duplicate them using Power query.
I can filter for the AND statements, but not when it get into the (3 or (5 and 6)) operation.
How do I do that in POwer BI?
When i compare the results of the Salesforce.com report using the above filters and my Power BI report, they do not match because i do not know how to include the (3 or (5 and 6)) operations into my query. That is where i need help.