cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Whatever2 Regular Visitor
Regular Visitor

Creating a function that aply in power query

Hello everyone 

 

I would like to create a function which is applied in Power Query before the dataset is loaded in Power BI 

Something like : " IF column1 = '' then delete  row" or really just any function that will apply automaticly

 

thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
Floriankx Established Member
Established Member

Re: Creating a function that aply in power query

Hello,

 

you can just filter the rows in Power Query, then they aren't loaded to BI.

 

But you also can as @ThomasFoster mentioned just filter the rows in BI.

 

CALCULATE(expression;FILTER(Table;Table[column1]<>"Value") which has similar effect.

View solution in original post

2 REPLIES 2
ThomasFoster Established Member
Established Member

Re: Creating a function that aply in power query

If you just want to delete rows that contain certain items then just filter the column

 

Power Query steps apply every time the data is loaded into the model.

Floriankx Established Member
Established Member

Re: Creating a function that aply in power query

Hello,

 

you can just filter the rows in Power Query, then they aren't loaded to BI.

 

But you also can as @ThomasFoster mentioned just filter the rows in BI.

 

CALCULATE(expression;FILTER(Table;Table[column1]<>"Value") which has similar effect.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,266)