Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

DAX Commands and Tips - Calculated Columns Issue

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

Anonymous
3 years ago
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.

ppm1
Solution Sage
3 years ago
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
- Anonymous
  Not applicable
  3 years ago
  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?
Anonymous
Not applicable
3 years ago
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.