topic Re: Converting Calculated column into Measure or IF statement return Alternative in DAX Commands and Tips

Converting Calculated column into Measure or IF statement return Alternative

Rabi — Fri, 13 Oct 2023 01:08:52 GMT

Hi Everyone,

How can I convert this Dax to measure,

CARER EXCESS = if([Additional hrs to meet target care min] <0,[Additiona hrs to meet target care min],0)*-1

Or Alternatively How can i return "-" instead of 0 in the same dad.

Regards,

Rabi

Re: Converting Calculated column into Measure or IF statement return Alternative

vicky_ — Fri, 13 Oct 2023 03:03:53 GMT

You can probably do so using the Dynamic Formatting Strings if you have a more recent version of powerbi: https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/.

Re: Converting Calculated column into Measure or IF statement return Alternative

Anonymous — Mon, 16 Oct 2023 09:43:30 GMT

Hi Rabi ,

Based on your description, I'm wondering that you want to change a negative number in a column of data to a positive number and replace the positive number with a "-"

I did a simple test and the result is as follows：

CARER EXCESS = VAR _1= if(MIN('Table'[Number]) <0,MIN('Table'[Number]),0)*-1 VAR _2 = IF(_1 = 0,"-",_1) RETURN _2

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.