Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
macemit
Frequent Visitor

Filter import on 2 conditions

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.

2 ACCEPTED SOLUTIONS

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?

 

 

View solution in original post

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.