Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX for Calulation column

I have column A, I want to create a 'calculation column' B.   The calculation function please find from B's calculation. 

 

Thanks!

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may use below dax to get the calculated column.

    Column =
VAR a =
    PRODUCTX (
        FILTER ( Data, Data[Index] <= EARLIER ( Data[Index] ) - 1 ),
        Data[A]
    )
VAR b = Data[A]
RETURN
    IF ( Data[Index] = 1, Data[A] * 1, a * b )

    Regards,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

    You may use below dax to get the calculated column.

    Column =
VAR a =
    PRODUCTX (
        FILTER ( Data, Data[Index] <= EARLIER ( Data[Index] ) - 1 ),
        Data[A]
    )
VAR b = Data[A]
RETURN
    IF ( Data[Index] = 1, Data[A] * 1, a * b )

    Regards,