Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Blank duplicate values

i have beow data and i need to supress the duplicate values to a single one 

current format

Expected format

 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a calculated column as below.

    Column = 
var min_date = CALCULATE(MIN('Table'[date]),ALLEXCEPT('Table','Table'[company name]))
return
IF('Table'[date]=min_date,'Table'[company name],BLANK())

     

     

    Best Regards,

    Jay

3 Replies