Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I would like to know if it is possible to add the values of the columa that says "Order Code" on a single line. Attached image
This is how the matrix display comes out when I add the order code column. I'd like you to come out this other way.
I do not know if with concatenatex or there is some dax function in which you can put it as in the imagne and so instead of appearing several lines per project that appears only one row.
The data is in different but related columns.
Thank you
Solved! Go to Solution.
Hi @Ion_Gomez ,
Create an index column in power query and a calculated column as below:
_Order number =
var _index=MAXX(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Order number]<>BLANK()),'Table'[Index])
Return
IF('Table'[Order number]=BLANK(),CALCULATE(MAX('Table'[Order number]),FILTER('Table','Table'[Index]=_index)),'Table'[Order number])
Then create a measure as below:
Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[_Order number]=MAX('Table'[_Order number])),'Table'[Order code],"-")
And you will see:
For the related .pbix file,pls click here.
Hi @Ion_Gomez ,
Create an index column in power query and a calculated column as below:
_Order number =
var _index=MAXX(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Order number]<>BLANK()),'Table'[Index])
Return
IF('Table'[Order number]=BLANK(),CALCULATE(MAX('Table'[Order number]),FILTER('Table','Table'[Index]=_index)),'Table'[Order number])
Then create a measure as below:
Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[_Order number]=MAX('Table'[_Order number])),'Table'[Order code],"-")
And you will see:
For the related .pbix file,pls click here.
Buenas Kelly,
I got what I wanted, the problem now is that it is repeated. it comes out this way..
Hello kelly couldo you please resende the pbx?
Thank you
@Ion_Gomez , you need to use concatenatex
https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
new measure = (Table,Table[cadigo pedio])
Hi @Ion_Gomez ,
you can try this this measure
Concat =
CONCATENATEX (
FILTER (
ALL (
'Table'[Codigo Proyecto],
'Table'[Codigo Pedio]
),
'Table'[Codigo Proyecto]
= MAX ( 'Table'[Codigo Proyecto] )
),
CALCULATE (
MAX ( 'Table'[Codigo Pedio] )
),
UNICHAR ( 10 )
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |