Forum Discussion
DAX help
Hi All,
I am trying to get a calculated column, If the same ID has any rejected values - create a column callyed Status Adjusted (column C is what I am trying to achieve) for that column to say rejected.
1 Reply
A new column
= var _cnt = countx(filter(Table, [ID] = earlier([ID]) && [Status] ="Rejected") , [ID])
return
if(isblank(_cnt) , "Accepted", "Rejected")
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
