Forum Discussion
Multiple value shown only once per certain row
Hello,
I was wondering if you could help me with obtaining this result - the first table is what I have, the second is what I need:
I know how to create a table using PowerQuery to show the repeating value only once (so only one "2222222", only one "333333") with the latest time, but I have problem to do it so the "Number" is shown with each "Type" separately.
Thank you in advance for your help.
Hello HannaK , you can create new table as below:
New Table = SUMMARIZE('Table','Table'[Type],'Table'[Number],"Max Time",MAX('Table'[Time]))Output looks like this:
Attached pbix for reference.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
2 Replies
Hello HannaK , you can create new table as below:
New Table = SUMMARIZE('Table','Table'[Type],'Table'[Number],"Max Time",MAX('Table'[Time]))Output looks like this:
Attached pbix for reference.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Yes, thank you! It now looks as intended.
