Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
[Pay Structure]="Net" then [#"Closed Premium "]*[#"Commission %"] else [#"Closed Premium "]*[#"Commission %"]+[Escrow Fee]
Solved! Go to Solution.
Try:
if [Pay Structure]="Net" then ([Closed Premium]*[Commission %]) else ([Closed Premium]*[Commission %])+[Escrow Fee]
You don't have to qualify special characters when referring to a [Column]. If you really do have a space at the end of [Closed Premium] as you do above, you'll have to include that or just remove it.
--Nate
Try:
if [Pay Structure]="Net" then ([Closed Premium]*[Commission %]) else ([Closed Premium]*[Commission %])+[Escrow Fee]
You don't have to qualify special characters when referring to a [Column]. If you really do have a space at the end of [Closed Premium] as you do above, you'll have to include that or just remove it.
--Nate