Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I got a database log that collect info about my picking rounds.
I´ve tried to create a new table that sums the info about the rounds but my DAX knowledge is unfortunatley not so good.
Reg-date | User | Pick-Code | Queue | Round | Weight | Volume |
2019-01-28 13:57:44 | 11111 | 3 | 10 | 55555 | 0,12 | 1,15 |
2019-01-28 13:55:30 | 11111 | 3 | 10 | 55555 | 1,00 | 8,21 |
2019-01-28 13:54:11 | 11111 | 3 | 10 | 55555 | 0,61 | 3,17 |
2019-01-28 13:53:38 | 11111 | 3 | 10 | 55555 | 0,22 | 3,31 |
2019-01-28 13:52:32 | 11111 | 3 | 10 | 55555 | 0,78 | 4,80 |
2019-01-28 13:51:38 | 11111 | 3 | 10 | 55555 | 1,56 | 9,60 |
2019-01-28 13:50:16 | 11111 | 3 | 10 | 55555 | 1,56 | 9,60 |
2019-01-28 14:00:02 | 22222 | 3 | 20 | 66666 | 1,45 | 15,14 |
2019-01-28 13:59:20 | 22222 | 3 | 20 | 66666 | 0,62 | 2,09 |
2019-01-28 13:58:42 | 22222 | 3 | 20 | 66666 | 0,84 | 5,25 |
2019-01-28 13:57:12 | 22222 | 3 | 20 | 66666 | 0,85 | 4,59 |
2019-01-28 13:56:20 | 22222 | 3 | 20 | 66666 | 1,89 | 5,87 |
2019-01-28 13:55:19 | 22222 | 3 | 20 | 66666 | 0,83 | 2,06 |
2019-01-28 13:53:49 | 22222 | 3 | 20 | 66666 | 1,86 | 18,58 |
2019-01-28 13:51:48 | 22222 | 3 | 20 | 66666 | 0,55 | 1,98 |
2019-01-28 13:51:16 | 22222 | 3 | 20 | 66666 | 0,03 | 0,18 |
2019-01-28 13:50:44 | 22222 | 3 | 20 | 66666 | 0,63 | 2,28 |
What i want to do is to create a table that looks like this. The round is distinct and a want to sum up weight and volume on my rounds and i want to show how many of "Pick codes" that is on the round.
From that table i will be able to create measures 🙂
Date | Round | User | Nr of codes | Queue | Weight | Volume |
2019-01-28 | 55555 | 11111 | 7 | 10 | 5,84 | 39,83 |
2019-01-28 | 66666 | 22222 | 10 | 20 | 9,54 | 58,01 |
Does anyone have a good DAX forumla idea?
I´ve tried SUMX and DISTINCT
Solved! Go to Solution.
@Tobjoh something like this and you can tweak as per your need:
Table 2 = SUMMARIZECOLUMNS( Table1[Reg-date].[Date], Table1[Round], Table1[User], Table1[Queue], "Nr of codes", COUNT( Table1[Pick-Code] ), "Weight", SUM(Table1[Weight]), "Volume", SUM(Table1[Volume] ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Tobjoh you can create new table using summarizecolumns DAX function
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Tobjoh something like this and you can tweak as per your need:
Table 2 = SUMMARIZECOLUMNS( Table1[Reg-date].[Date], Table1[Round], Table1[User], Table1[Queue], "Nr of codes", COUNT( Table1[Pick-Code] ), "Weight", SUM(Table1[Weight]), "Volume", SUM(Table1[Volume] ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
You solved it 🙂
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |