Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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?
Hi,
In the Query Editor, use the Text.Length function and then filter that column with a criteria of 13.
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
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?
Hi,
In the Query Editor, use the Text.Length function and then filter that column with a criteria of 13.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |