Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |