ConcatenateX in Power BI and DAX Concatenate Values of a Column

preview_player
Показать описание
It happens often in Power BI calculations and reports that you need to concatenate a list of values from a column. You can do this concatenation in Power Query or DAX. However, if the concatenation needs to be done dynamically. ConcatenateX is a very helpful DAX function to achieve such results. It is very helpful to understand what happens in the virtual tables in DAX too. In this article and video, I’ll explain what ConcatenateX is and how it works in Power BI and DAX.
Get the codes and find more information from my blog article here:
*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD
  1. RADACAD
  2. power bi
  3. power bi tutorial
  4. power bi desktop
  5. DAX
  6. DAX functions
Рекомендации по теме
ConcatenateX in Power 0:12:23

ConcatenateX in Power BI and DAX Concatenate Values of a Column

Create insightful calculations 0:12:27

Create insightful calculations using CONCATENATEX.

15.1 How to 0:04:28

15.1 How to Use CONCATENATE, CONCATENATEX Text Functions in DAX | DAX in Power BI

Use CONCATENATEX to 0:20:02

Use CONCATENATEX to Create Smart Visuals in Power BI

Using CONCATENATEX in 0:04:03

Using CONCATENATEX in DAX

Debugging DAX in 0:09:38

Debugging DAX in Power BI with CONCATENATEX

CONCATENATE AND CONCATENATEX 0:06:32

CONCATENATE AND CONCATENATEX in Microsoft Power BI

DAX Language - 0:06:35

DAX Language - CONCATENATE and CONCATENATEX Functions in Power BI

CONCATENATE, CONCATENATEX - 0:01:48

CONCATENATE, CONCATENATEX - DAX Guide

Using DAX CONCATENATEX 0:07:30

Using DAX CONCATENATEX to list values vertically in a Card Visual

Explore your DAX 0:10:48

Explore your DAX using CONCATENATEX

Power BI Tutorial 0:04:17

Power BI Tutorial Series for Beginners Part 43: Concatenatex

Concatenatex Function DAX 0:00:44

Concatenatex Function DAX - DAX Concatenatex Function In Power BI Desktop | DAX Tutorials

Power BI Dax 0:12:13

Power BI Dax ConcatenateX

DAX | Power 0:06:50

DAX | Power BI | TEXT | Combinevalues, Concatenate and ConcatenateX Functions

POWER BI DAX 0:10:58

POWER BI DAX | COMBINEVALUES | CONCATENATE | CONCATENATEX | #education #powerbi #dax #datanalytics

CONCATENATEX - POWER 0:05:56

CONCATENATEX - POWER BI - DAX

Power BI CONCATENATE 0:07:58

Power BI CONCATENATE & CONCATENATEX function

COMBINEVALUES, CONCATENATE & 0:08:45

COMBINEVALUES, CONCATENATE & CONCATENATEX DAX in Power BI#dax #powerbi #dataanalytics #analytics

CONCATENATEX Vs CONCATENATE 0:13:37

CONCATENATEX Vs CONCATENATE [Power BI Tamil - 13/50]

Power BI (desktop) 0:11:20

Power BI (desktop) - Formatação Condicional e CONCATENATEX

#powerbi #dax #text 0:08:53

#powerbi #dax #text #functions #combinevalues #concatenate #concatenatex (Video - 29)

#powerbi #selectcolumn#addcolumn#powerbi#concatenate#concatenatex# (Tutorial 0:11:12

#powerbi #selectcolumn#addcolumn#powerbi#concatenate#concatenatex# (Tutorial -28)

ConcatenateX | How 0:06:49

ConcatenateX | How to Create Dynamic Labeling in Power BI

Комментарии
Автор

Hi I'm Kavitha I have a doubt on power bi. I want to display one month top 5 category and subcategory by creating a table can you explain pls

kavithunga
Автор

I request you sir, please do a video on the entire " Date & Time Dax " functions.

venkatareddykummitha
Автор

Sir, how about if I'd like to get a data from a table that contains this text (i.g "PR" since there are 7, 000 words in that table which contains "PR") and would like to assign categorized this "PR" into "Raptor" for example.. can you help me write a syntax for that, please?

macmarcos
Автор

Hi, thanks for your video! I'm unsure if anyone can assist me, but I'm struggling to concatenate multiple values separated by different columns (all in the same row). However, some columns have values and others do not, and I need to separate them by using a comma as a delimiter (only when there is a value). Is anyone has any idea how I can do that? I guess I need to use a conditional function, but not sure about it.

constantinoooo
Автор

Hi

when ever the normal page refresh happens in Power BI services i will be getting error like ""

I am getting this error after updating my credentials also, each time i refresh different data sources are showing the error.

Any thoughts on this?

muralikrishna