this is my table named Workers
Name | Date | Type |
Sam | 3/14/2022 | 1500 |
Sam | 3/19/2022 | 2000 |
Sam | 3/18/2022 | 300 |
Sam | 3/11/2022 | 58 |
Sam | 3/20/2022 | 4877 |
How do I get it to this?
Name | MaxDate | Type |
Sam | 3/20/2022 | 1500, 2000, 300, 58, 4877 |
Solved! Go to Solution.
@PaulPalkowski add a measure :
Type Measure =
CONCATENATEX ('Table', 'Table'[Type],"," )
In a table visual, use Name, MAx of Date, and above measure and you will have the output
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@PaulPalkowski add a measure :
Type Measure =
CONCATENATEX ('Table', 'Table'[Type],"," )
In a table visual, use Name, MAx of Date, and above measure and you will have the output
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
How can I get that to a new table?
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
215 | |
48 | |
44 | |
44 | |
41 |
User | Count |
---|---|
270 | |
211 | |
103 | |
75 | |
64 |