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.
Hi all,
I am having trouble processing data in power BI.
Can you help me make all of FABRIC CODE each OUT DOCUMENT become a row (the fabric code a comma separated list).
I am very grateful for this.
Thank you!!!
Solved! Go to Solution.
maybe you can try this
Proud to be a Super User!
I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column
Proud to be a Super User!
My data source same this
maybe you can try this
Proud to be a Super User!
Yes, thank you!
I have done it before. However, my source data contained a lot of rows... and they outputted everything.
Do you have any other way?
do you mean duplicated fabric code?
i tried to reproduce the situation, the measure does not combine the repeate fabric code.
could you pls provide the sample data?
Proud to be a Super User!
Oh Yes I made it... Woww... thank you, thank you so much 😘
you are welcome
Proud to be a Super User!
Wow, that is result of your formula... only it doesn't follow OUT DOCUMENT
you need to remove the " farbric doe customer " column
Proud to be a Super User!
the same this...
Data row is very large. Looks like I need to filter them before using CONCATENATEX... but I don't know how to make
still can't reproduce the issue.
is it possbile to share the pbix file after removing sensitive data?
Proud to be a Super User!
do you have a way to not have to show its total on the report table?
turn off the total
or
update the DAX
Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))
Proud to be a Super User!
I don't know why I use this formula it's not run
Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))
you can also try this
Proud to be a Super User!
I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column
Proud to be a Super User!
It's okay... thank you so much!!!
you are welcome
Proud to be a Super User!
wow, I'll use the 2nd method... because I also need to show total of some other columns.
you are really cool
thank you!!!
you are welcome
Proud to be a Super User!
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |