Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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,
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,
Hi, @v-cherch-msft
Thank you for your help.
I found a solution. I created several measures to replace these columns.
Best regards.
Wei
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |