The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
[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