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
Appologies for the confusion...
Want i want to achieve with the measure for sparepart count is creating a pivot table with unique spartpart in rows and months in columns so that I can use slicers for Brand/Product/Region etc to get more insights
When i use the my measure or the one suggested I am getting incorrect counts...
The print you've provided doesn't include any date or month information...
How is that included in your model?
jpessoa8 heres and updated picture
For months i have added an column using format("mmm-yy") for created and closed month
Dates are in dd-mm-yy format
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