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,
This 2 table below actually come from same table in model.
How can I show the 2nd table (workorder) in table 1 as new column in 1 row and separate by comma?
as example it will be something like below:
Count of Workorder | Workorder
6 | 2021025087, 2021025098, 2022002469, 2022005246, 2022007304, 2022007706
Solved! Go to Solution.
Great. I modified your function as below and got the expected results.
List of WO = calculate(CONCATENATEX('Planner Combine','Planner Combine'[Workorder],", "),TREATAS(SUMMARIZE('Planner Combine','Planner Combine'[Weekly Commitment]),'Planner Combine'[Weekly Commitment]))
has any way i want to exclude total of 'List of WO' from the table?
If I reproduce your tables with Article Nr as the key, you should get :
Workorder :
Great. I modified your function as below and got the expected results.
List of WO = calculate(CONCATENATEX('Planner Combine','Planner Combine'[Workorder],", "),TREATAS(SUMMARIZE('Planner Combine','Planner Combine'[Weekly Commitment]),'Planner Combine'[Weekly Commitment]))
has any way i want to exclude total of 'List of WO' from the table?
Ok,
I have created the table with only Article nr. and Workorder :
Count of Workorder is distinctcount
Hi @JYA,
actually the data was group to 3 column in red crop below.
i try use u formula sir but seems its not work.
I think is better if i able attach my pbix file but seems this forum dont have that features.
Hi,
you can add a measure of this kind :
Workorder full = CONTATENATEX('WorkOrder','Workorder'[Workorder], ", ")
Of course you need to filter on same key but you have not provided it in your message.
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 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |