Forum Discussion

pmthu's avatar
pmthu
New Member
4 years ago
Solved

How to find duplicated data in first column based on second column and show result as Status

Hi All,   I have one thing to solve.I want to add new column as "Complete or Not" deponding on Action Column.If one date have sign_in and sign_out,data in new column is "Complete" for that date. P...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi pmthu ,

     

    Try this DAX formula.

    Column = 
var _distinct = CALCULATE(DISTINCTCOUNT('Table'[action]),filter(ALLEXCEPT('Table','Table'[date]),'Table'[action]<>BLANK()))
return
IF(_distinct=2,"complete","not")

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi pmthu ,

 

Try this DAX formula.

Column = 
var _distinct = CALCULATE(DISTINCTCOUNT('Table'[action]),filter(ALLEXCEPT('Table','Table'[date]),'Table'[action]<>BLANK()))
return
IF(_distinct=2,"complete","not")

 

Best Regards,

Jay