add "bps" to divide function in Power BI

[Anonymous]

Hi Experts

How would you add "bps" to the result of the following formula...

Product Margin bps vs PY1 = DIVIDE([Product Margin (Gross Margin) PY],[Total Revenue PY],0)*10000-DIVIDE([Product Margin GM @ PY Rate BM - Reported],[Net Sales @ PY Rate BM - Reported],0)*10000
        &"bps" 

The above is my try....

end result should be -30 bps.....

currently the above gives me -29.784.....

[PattemManohar · Accepted solution]

@Anonymous Please give a try with this !!

Product Margin bps vs PY1 = CONCATENATE(FORMAT(DIVIDE([Product Margin (Gross Margin) PY],[Total Revenue PY],0)*10000-DIVIDE([Product Margin GM @ PY Rate BM - Reported],[Net Sales @ PY Rate BM - Reported],0)*10000,0)," bps")

[Anonymous]

many thanks for the excellent feedback

[Anonymous]

you can use Concatenate function

=CONCATENATE([Product Margin bps vs PY1]," BPS")