Forum Discussion
Counting values per column
Hi, here a question that I thought should be very simple. But after searching for a while on this forum and trying it myself I haven't found an answer yet. Maybe I'm overlooking a simple solution. ...
Start by unpivoting your data
after than you can do a count of the completed and divide i with the total
NickolajJessen
Solution Sage
Solution SageDo you have the option to unpivot your data in power query?
Never used unpivot in Power BI before, but I looked up some documentation about this option and see the point of transforming this table to a more usable form. I am going to work on this.