Forum Discussion
RKM
Helper IV
Helper IVDerived Column based on Previous Value in Same
Dear Experts, I have apparantly simple problem but finding it hard to resolve. So, I got a table with 2 columns in Power BI as below. Item ID----Session A ----1 A ----2 B ----1 B ----4 B ----...
RKM , Try a new column like
new column =
var _cnt = countx(filter(Table, [In_Session] = earlier([In_Session]) -1 && [Item_ID] = earlier([Item_ID])), [Item_ID])
return
if( isblank(_cnt) , "Yes", "No")
amitchandak
Super User
Super UserRKM , Try a new column like
new column =
var _cnt = countx(filter(Table, [In_Session] = earlier([In_Session]) -1 && [Item_ID] = earlier([Item_ID])), [Item_ID])
return
if( isblank(_cnt) , "Yes", "No")
RKMThanks a lot amitchandak . Exactly what I wanted.