Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |