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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dsandip
Frequent Visitor

how to use if clause in power query?

Hi,

I have used below in my Power Query:

Table.AddColumn(#"Changed Type3", "Custom Consumer ID", each if each Text.Contains([DIM_OPS_CNDCT_PRODUCT_KEY], "Package SME") = true then 2 else [DIM_SEGMENT_ID])

 

Now, I am getting error, at 

each if each Text.Contains([DIM_OPS_CNDCT_PRODUCT_KEY], "Package SME") = true

as 

"Expression.Error: We cannot convert a value of type Function to type Logical.
Details:
Value=[Function]
Type=[Type]"

 

Can any one help me that, how can I write that IF then ELSE cuase.

 

 

Thanks,

Sandip

 

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

Hi,

According with error message the problem is here: 

_AAndrade_0-1708599736660.png

 

Try to delete thar "each"





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

2 REPLIES 2
_AAndrade
Super User
Super User

Hi,

According with error message the problem is here: 

_AAndrade_0-1708599736660.png

 

Try to delete thar "each"





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




just overlooked the extra each

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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