Combine Multiple Rows into a Single Cell
In Excel
0:00 / 0:00
Combine Multiple Rows into a Single Cell
230 просмотров · 9 дн. назад
In Excel
48 подписчиков
230 просмотров · 9 дн. назад
Direct Contact & Inquiries:
amwinchumu@yahoo.com
In this video, you’ll learn how to use a DAX measure with the CONCATENATEX function that combines multiple values into a single cell in a PivotTable. I hope you find it helpful!
00:00 Introduction
01:57 Creating a Measure (CONCATENATEX)
03:14 Remove Grand Total Row
04:06 Remove values in Grand Total Row
04:37 Maintain distinct values