Format of Switch Function As Currency

[DW868990]

Hi, 

I have the below switch function, however I need the output to be shown as currency - £##,###.##

Is there a possible way round this? Thanks in advance

Yes/No Metric Selection =

VAR Selection = SELECTEDVALUE(Table1[Metric])

VAR Result =

SWITCH(TRUE()

    ,Selection = "Product1", CALCULATE([Measure], USERELATIONSHIP(Table1[Flag],Table2[Product1]))

    ,Selection = "Product2", CALCULATE([Measure], USERELATIONSHIP(Table1[Flag],Table2[Product2]))

    ,Selection =  "Product3", CALCULATE([Measure], USERELATIONSHIP(Table1[Flag],Table2[Product3]))

    ,Selection =  "Product4", CALCULATE([Measure], USERELATIONSHIP(Table1[Flag],Table2[Product4]))

    ,Selection =  "Product5", CALCULATE([Measure], USERELATIONSHIP(Table1[Flag],Table2[Product5]))

)

RETURN

Result

[amitchandak · Accepted solution]

@DW868990 , if they all are of the same format, you can write the same format in measure tool format or in the data model->property pane format

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

if you need a different format then use field parameters 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

[DW868990]

Perfect! Thank you