Filter import on 2 conditions

[macemit]

Hi,

New to Power BI. I am importing a table from Salesforce every couple of days (this I can do). However, I would like to only import data after a ship_date of January 1, 2017, and based on a specific serial number length of 13 characters.

Would I do this in query editor? Does it necessitate a formula?

Thanks.

[macemit · Accepted solution]

Thanks. What I am trying now is to simply set the date column filter to after a specific date. Is there a text filter I can use to filter out any serial numbers that do not contain 13 characters?

[Greg_Deckler]

I would probably create two custom columns (or a single one) that did the necessary calculation(s) to flag the rows that you want and then just filter on that column. Tough to say exactly without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[macemit · Accepted solution]

Thanks. What I am trying now is to simply set the date column filter to after a specific date. Is there a text filter I can use to filter out any serial numbers that do not contain 13 characters?

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, use the Text.Length function and then filter that column with a criteria of 13.