Blank duplicate values

[Anonymous]

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

current format

Expected format

[Anonymous]

Hi, I want the same but reverse. I have a single value but I want to duplicate it 

[Anonymous · Accepted solution]

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

[amitchandak]

@Anonymous , You can display in a matrix with the stepped layout https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#stepped-layout-with-matrix-visuals