Data Conversion (Number to Currency) not applying inside measure.

HillUser1 — Wed, 22 Apr 2020 19:52:54 GMT

Inside my report, the user uses a slicer to narrow down to a single specific project. It will then show data related to a single project and evaluate the project status based on a couple of indicators. It appears that when I try to report a number with the SELECTEDVALUE command I do not receive any previous formatting I made in the modeling tab. When I also try to manually apply a conversion inside the DAX I do not get the expected results. The SELECTEDVALUE remains a number. ROUND command works.

What is the proper way to perform this action?

Current Result: Billing was $2229.50 over the actual cost for the past 2 months.

Expected Result: Billing was $$2,229.50 over the actual cost for the past 2 months.

Current DAX Formula:

Measure 1 =

SWITCH(TRUE(),

ISBLANK(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])),"Calculation Error",

SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])>0,"Billing was $" & CURRENCY(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])) & " over the actual cost for the past 2 months",

SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])<0,"Billing was $" & (ROUND(SELECTEDVALUE(V_PBI_HMC_JOB_PROJECTION_DATA[LogicSegment11_0])*-1,0)) & " under the actual cost for the past 2 months")

Re: Data Conversion (Number to Currency) not applying inside measure.

AilleryO — Thu, 23 Apr 2020 07:56:02 GMT

Hi,

Instead of your CURRENCY function, did you try with a FORMAT function ?

FORMAT(myvalue,"$ #,###.00")

Tell us if it works...

Have a nice day

Re: Data Conversion (Number to Currency) not applying inside measure.

HillUser1 — Fri, 24 Apr 2020 18:20:10 GMT

Thank you for your help. It worked and is exactly what I needed.

For Additional information and Options on the format fucntion:

Other use: FORMAT( 12345.67, "Currency")

Link: https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function

topic Data Conversion (Number to Currency) not applying inside measure. in DAX Commands and Tips

Data Conversion (Number to Currency) not applying inside measure.

Re: Data Conversion (Number to Currency) not applying inside measure.

Re: Data Conversion (Number to Currency) not applying inside measure.