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
ā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