Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.