Forum Discussion
Solved
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 s...
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!!
Kishore_KVN
Solution Sage
Solution SageHello 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.