Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to delete duplicate columns

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.

 

General Comment
Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

2 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, v-cherch-msft 

      Thank you for your help.

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

       

      Best regards.

       

      Wei