Forum Discussion
Solved
ALL excepect function with if condition
Greeting members , i want to create a calculated column using IF and all expect if possible . here is a sample of data : i want to create the G.Note column , this column will...
Rayzo92 ,
new column =
var _cnt = countx(filter(Table, [id] <earlier([ID]) && [Note+] = earlier([Note+]) ), [ID])
return
if(isblank(_cnt) , [Note+], null)
Rayzo92 ,
new column =
var _cnt = countx(filter(Table, [id] <earlier([ID]) && [Note+] = earlier([Note+]) ), [ID])
return
if(isblank(_cnt) , [Note+], null)