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 have 2 columns that look like this
Now I want to create a custom column that shows "TRUE" when
ID=68 and
Included = TRUE
How do write this in Power Query?
Solved! Go to Solution.
This should work
= if [BoatIncludeExcludeId] = 68 and [InFulllEquipmentPackage] = true then true else false
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous ,
You can also create a custom column like so:
= if [ID] = 68 and [Included] then true else false
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
clike Add Column ---> Custom Column, and input this formula
= [BoatIncludeExcludeItemId] = 68 and [Included]
Hi @Anonymous ,
You can also create a custom column like so:
= if [ID] = 68 and [Included] then true else false
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This should work
= if [BoatIncludeExcludeId] = 68 and [InFulllEquipmentPackage] = true then true else false
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.