I have column A, I want to create a 'calculation column' B. The calculation function please find from B's calculation.
Go to Solution.
You may use below dax to get the calculated column.
VAR a =
FILTER ( Data, Data[Index] <= EARLIER ( Data[Index] ) - 1 ),
VAR b = Data[A]
IF ( Data[Index] = 1, Data[A] * 1, a * b )
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.