Forum Discussion
Create a table where each row has a specific formula
I ended up creating columns for each check and then more columns for each summary and suming them up from all the entries.
Super UserYes, this makes sense. Yes, you would probably need to combine the logic using IF or SWITCH statments in DAX, or look at doing transformations in Power Query.
Or, you could keep the excel spreadsheet as is and use it as the datasource for your Power BI report.
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.