Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |