Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jcastr02
Post Prodigy
Post Prodigy

Pivot Columns

Hello,  Please see the Current data set up and future .  How can I achieve this?  I have tried all pivot columns options but none are providing this result.  Any thoughts?

 

pivot.png

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

Pls try this

 

=  
VAR _t = MAX('table'[ID])
RETURN
CONCATENATEX(FIILTER(ALL('table'),'table'[ID]=_t),[CURRENT WFM],";")

 

View solution in original post

3 REPLIES 3
Ahmedx
Super User
Super User

Screenshot_1.png

Ahmedx
Super User
Super User

Pls try this

 

=  
VAR _t = MAX('table'[ID])
RETURN
CONCATENATEX(FIILTER(ALL('table'),'table'[ID]=_t),[CURRENT WFM],";")

 

mlsx4
Memorable Member
Memorable Member

Just a little correction on your formula. Filter has two "I", @jcastr02 wants a ";" as delimitator and adding a space will result in a more legible way:

 

 

Measure=

VAR _t = MAX('MyTable'[ID])
RETURN
CONCATENATEX(FILTER(ALL('MyTable'),'MyTable'[ID]=_t),[WFM],"; ")

 

 

But @Ahmedx formula is perfect

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.