March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi colleagues,
I would like to have your support about the topic below:
I have one table (summarized table) including multiple lines for each "Company" with different audit status.
Is it possible to combine all these line, and resume the audit status in one line for each supplier ?
Target is to move from Table 1 to Table 2:
Company | Audit 1 | Audit 2 | Audit 3 | Audit 4 |
X | valid | |||
X | planned | |||
X | ||||
X | expired | |||
Y | expired | |||
Y | planned | |||
Y | planned | |||
Y | valid | |||
Z | expired | |||
Z | planned | |||
Z | valid | |||
Z | valid |
Thanks for your support !
Best regards.
Solved! Go to Solution.
Hi @Anonymous
You can also acheive your output through Power Query..Attached is the screenshots and Power Bi file..
have a look
Regards
sanalytics
Hi @Anonymous ,
I have done tests and think the solution provided by @AlexisOlson works, refer to the following.
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , in power query, create a table using group by and use min/max for all columns other than company
https://docs.microsoft.com/en-us/power-query/group-by
@amitchandak First, thanks for your reply.
As my table is a result of "summarize" function, I can't use the "group by" ==> when i open power query my table isn't there.
Is there any other solution please ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
86 | |
77 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |