topic Re: DAX Commands and Tips - Calculated Columns Issue in DAX Commands and Tips

DAX Commands and Tips - Calculated Columns Issue

Anonymous — Thu, 15 Dec 2022 13:31:35 GMT

Hi.

I have 3 calculated columns:

Co1_1: = Units/Weeks

Result = 2.7

Col_2: = Capacity/(Col_1)/7

Result = 10.5

Col_3 = Col1*Col2

Result = 28.0

It should be 28.4

Any help. Thank you

Re: DAX Commands and Tips - Calculated Columns Issue

ppm1 — Thu, 15 Dec 2022 13:39:26 GMT

I suspect you have the formatting for your columns to show one decimal place. Increase that on the two input columns and you will likely see that 28.0 is correct. The original values are used in the calculation, but the format string controls how it is displayed.

Pat

Re: DAX Commands and Tips - Calculated Columns Issue

Anonymous — Thu, 15 Dec 2022 14:03:44 GMT

Hello. So far not solved yet. All of my fields (columns) are Date type=Decimal & Format Decimal=Decimal Number. All the calculation is doing is taking (L52_Avg_Mvmt)*L52_DOS_W) and it just keeps returning a whole number even with format set to decimals.

Re: DAX Commands and Tips - Calculated Columns Issue

Anonymous — Thu, 15 Dec 2022 14:27:56 GMT

I took this same calculation out to excel (copied it from powerpivot). If i have 2 decimal places it should show decimals and not whole numbers. Any ideas?