Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Hi,
According with error message the problem is here:
Try to delete thar "each"
Proud to be a Super User!
Hi,
According with error message the problem is here:
Try to delete thar "each"
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |