Forum Discussion

Anonymous's avatar
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 yo...
  • Anonymous's avatar
    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's avatar
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's avatar
    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?