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 UserHi Help_Required ,
I'm not totally sure what you are looking for. Are you asking how to replicate the excel formulas in each column to determine compliance?
So in excel I can create a table and use different formulas for each line of the column to give summary calculation but don't seem to be able to do that in power bi everything has to be calculated the same way in a single column, so take one of the section, "status reporting" this is claculated by counting the number of projects that have a certain value in the reporting compliance column but the "issues and risks" is a count for a diferent column. I have 6 different columns to count but only 1 formula. Hope this makes sense?
- djurecic
Yes, 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.