topic Re: Calculated Column in DAX Commands and Tips

Calculated Column

sdhn — Wed, 19 Jan 2022 22:56:03 GMT

Hi all,

I need to create calculated column in power bi as below:

Column =(col1-col2)/col2

Will appreciate your help.

Re: Calculated Column

VahidDM — Wed, 19 Jan 2022 22:59:00 GMT

Hi sdhn

Can you share a sample of your data in a text format?

BTW, try this:

Column =([col1]-[col2])/[col2]

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Calculated Column

sdhn — Wed, 19 Jan 2022 23:14:35 GMT

Sum values come in new column come as "NaN" & in one row value of New Column is "Infinity". Rest rows are fine. Any advise Thanks

Re: Calculated Column

sdhn — Wed, 19 Jan 2022 23:24:33 GMT

If both columns have "0" value output come as NaN

Column =([0]-[0])/[0]

output is "NaN"

in one row I have value for column 1 = 13

column 2 = 0

Column =([13]-[0])/[0]

Out put is infinity

Re: Calculated Column

VahidDM — Wed, 19 Jan 2022 23:31:37 GMT

sdhn

Try this:

Column =IF([col2]=0,blank(),([col1]-[col2])/[col2])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Calculated Column

sdhn — Thu, 20 Jan 2022 02:07:14 GMT

Great , thi ssolve the issue. One more request.

I am getting negative figures in few rows.

as -0.3 %. I want to display any "-" as '0'. Can you help on this too? thanks

Re: Calculated Column

sdhn — Thu, 20 Jan 2022 02:07:56 GMT

I meant Just display 0 if there is any negative "-" number

Re: Calculated Column

VahidDM — Thu, 20 Jan 2022 02:22:27 GMT

Hi sdhn

try this:

Column = IF ( [col2] = 0, BLANK (), IF ( [col1] - [col2] < 0, 0, ( [col1] - [col2] ) / [col2] ) )

If my posts helps, please consider accepting them as solutions to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Calculated Column

sdhn — Thu, 20 Jan 2022 16:25:12 GMT

Thanks, great help