Forum Discussion

collmomo's avatar
collmomo
Advocate I
9 years ago
Solved

Measure to Calculated column

I have this measure which was created like that DIO Year-End := ([Net Inventory Month End]*91/[Total COS (Adj.) 3 Mths]) Net Inventory Month End := CALCULATE(SUM(Actual[Amount]),Actual[ID]=1)...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi collmomo,

    It is working but I needed to make an average out of this thus I created a calculated column.

    In this scenario, you should be able to use AVERAGEX Function (DAX) to create a measue to calcuate the average, without creating the calculate column. The formula below is for your reference.:smileyhappy:

    Avg DIO Year-End = AVERAGEX ( Actual, [DIO Year-End] )

    Regards

parry2k's avatar
parry2k
Super User
9 years ago

Can you share your calculated column expression?

collmomo's avatar
collmomo
Advocate I
9 years ago

It's the same thing

 

DIO Year-End = ([Net Inventory Month End]*91/[Total COS (Adj.) 3 Mths])