How to delete duplicate columns

[Anonymous]

Hi,

I created a measure "AB" and selected two periods (C::2018.06 and R::2018.06), but it generated duplicate columns. 

Please tell me how to delete these duplicate columns.

I am looking forward to hearing rom you soon.

Best regards.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create a measure like below.It could hide the values under C::2018.06.Use the measure instead of [AB] in the matrix.

Measure =
IF ( MAX ( 'Table'[name] ) = "C::2018.06", BLANK (), 'Table'[AB] )

Regards,

[Anonymous]

Hi, @v-cherch-msft 

Thank you for your help.

I found a solution.  I created several measures to replace these columns.

Best regards.

Wei