Forum Discussion
Solved
Create a table where each row has a specific formula
I have used power query for years and I am trying to move to power bi. I have a view I created in excel that I am trying to replicate in power bi, where we count the # of projects that are compliant ...
I ended up creating columns for each check and then more columns for each summary and suming them up from all the entries.
Not sure what you mean, I have tried all sorts to date, looked at counting through meaures, creating column for each check, even looking to create a a table with list of the column names and tring to make that a variable. To no avail, surely I cannot be the only person having this issue, but maybe I need to start fresh, trying to replicate maybe my issue, what do people suggest I need to do to arrive at this type of view? What should my raw data table look like?
I ended up creating columns for each check and then more columns for each summary and suming them up from all the entries.