Convert If ISNull and Select Case from Crystal to Report Builder

[ResearchDev]

What is the best approach of converting Crystal code expressions to a PowerBi Report Builder expression? The I am not very familiar on how to set this up. Could you show when how to get 
the logic started in this?Thanks
----------------------------------------

if Sum ({PROPOSALVENDOR.AWARDED}, {PROPOSAL.CALLORDER}) = 0 then
(if {PROPOSALVENDOR.VENDORRANKING} = 1 then
(shared numberVar ProposalVendor_ID := {PROPOSALVENDOR.PROPOSALVENDOR_ID};
shared numberVar BidTotal := {PROPOSALVENDOR.BIDTOTAL};
shared stringVar Vendor := {REFVENDOR_DBE.VENDORNAME}))
else if Sum ({PROPOSALVENDOR.AWARDED}, {PROPOSAL.CALLORDER}) <> 0 and {PROPOSALVENDOR.AWARDED} = 1 then
(shared numberVar ProposalVendor_ID := {PROPOSALVENDOR.PROPOSALVENDOR_ID};
shared numberVar BidTotal := {PROPOSALVENDOR.BIDTOTAL};
shared stringVar Vendor := {REFVENDOR_DBE.VENDORNAME});

if shared numberVar ProposalVendor_ID <> 0 and {PROPOSALVENDOR.AWARDED} <= 1 then
shared numberVar ProposalVendor_ID;
shared stringVar Vendor;
shared numberVar BidTotal;

[ResearchDev]

This is for Report Builder and not PowerBI Dashboard. The Report builder is like the SSRS version but a stand alone. The above code is for 1 field only. There are many textbox with many expressions some easy while others like this or more.

[davehus]

Hi @ResearchDev , I'd suggest creating this in power query using a conditional column.