Forum Discussion

vat2do's avatar
vat2do
Helper III
2 years ago

create new column from duplicate values with condition

Hi everyone, I have below table in powerbi desktop   Ticket number breached status Unique Ticket Numbers 1234 true closed   1234 false closed   1020 false closed   1020 ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

vat2do 

is this what you want?

Column = 
VAR _check=maxx(FILTER('Table','Table'[Ticket number]=EARLIER('Table'[Ticket number])&&'Table'[breached]=True()),'Table'[Ticket number])
return if (ISBLANK(_check),'Table'[Ticket number],BLANK())

  • vat2do's avatar
    vat2do
    Helper III
    2 years ago

    Thanks for your response but i need the output as mentiined below:

     

    1234

    1020

    1452

    Means shoukd have all the unique values with "false" status.

    •  

     

    •  

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      still don't understand. could you pls create the output in excel and paste the screenshot here?