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
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!