Power BI table value appear once if they have same values on other columns

[peternznguyen]

Hi experts,

I have below Power BI data table, the current values of column "Production comments"  are showing repeatedly if they have same the Date as below

My end users want the values of "Production comments" appear once if they have same Date as in green boxes below

I have tried to use Matrix (+/- icons and Stepped Layout are off) instead of Table but it does not achieve due to various reasons.

Please help me to find a solution

Much appreciated

[v-yanjiang-msft · Accepted solution]

Hi @peternznguyen ,

According to your description, I create a sample.

Here's my solution:

1. Add an index column in Power Query.

2.Create a calculated column.

Column =
IF (
    'Table'[Index]
        = MINX (
            FILTER ( 'Table', 'Table'[Date] = EARLIER ( 'Table'[Date] ) ),
            'Table'[Index]
        ),
    'Table'[Production comments],
    BLANK ()
)

Get the correct result:

I attach my sample below for your reference.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Community Support Team_yanjiang

[peternznguyen]

Thank you very much!