Forum Discussion
Count from multiple columns
Adding the date columns to dataset following the Unpivot approach, the next step is to had a Date table and relate it to the existing tables via DateStart
With that, you can drap a month column in a matrix with the spareparts and add the measure for counting:
Here is the PowerBI version with this implementation: https://we.tl/t-dpKfsMa7sx
Hope this answer solves your problem!
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
Hi Avicric ,
What I was missing in my approach was specifying the type of SparePart.
With that information, the only difference is to relate unpivoted table I've suggested with the SpareParts list table:
With this you can see the information either by CaseID or SparePart item:
Here is the revised PowerBI file : https://we.tl/t-CSZCMgmdYh
For additional help, please @ me in your reply!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
