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 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.