Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I would like to replicate the similar conditional column in Power Query, How should I do it?
IF(
Attribute("Spend Category") !=null
&& Attribute("Spend Category").Substring(0,2).In(
[
"ZZ"
]
),
"No",
"Yes"
)
Thank you
Solved! Go to Solution.
@alice11987 Try the following:
#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if Text.StartsWith([Spend Category], "ZZ") and Spend Category] <> null then "No" else "Yes")
where "#Changed Type" should be changed to the appropraite names that your data preparation step is using.
@alice11987 What are you wanting to acheive in English? I'm not familiar with the code you've posted, but if I understand it correctly I agree with @johnyip
In Power Query, click Add Column > Custom Column , and then paste this code:
if Text.Contains(Text.Start([Spend Category], 2), "ZZ") and [Spend Category] <> null then "No" else "Yes"
If you have a list of other things that you need to include (not just "ZZ"), then try:
if List.Contains( {"ZZ", "DD"}, Text.Start([Spend Category], 2)) and [Spend Category] <> null then "No" else "Yes"
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@alice11987 Try the following:
#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if Text.StartsWith([Spend Category], "ZZ") and Spend Category] <> null then "No" else "Yes")
where "#Changed Type" should be changed to the appropraite names that your data preparation step is using.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |