Forum Discussion
Survey Data Responses - transform data
Hi GrahamC1
You need to set up some buckets for the outputs either in the Query editor with a conditional column inserted into your data structure or in desktop using the UI functionality Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn this way you can map the replies to the Outputs of Favorable, neutral etc.
In regards to your wider custion about countifs you can use a number of DAX functions, but if you have not built a Star Schema data model, and you are using your flat excel file, then this is why you arr running into issues. Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Hope this helps, I ahve built lots of surveys like this in Power BI so please feel free to ask for a more specfic answer.
The choice is yours to which way you want to do this.
Hi GrahamC1
You need to set up some buckets for the outputs either in the Query editor with a conditional column inserted into your data structure or in desktop using the UI functionality Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn this way you can map the replies to the Outputs of Favorable, neutral etc.
In regards to your wider custion about countifs you can use a number of DAX functions, but if you have not built a Star Schema data model, and you are using your flat excel file, then this is why you arr running into issues. Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Hope this helps, I ahve built lots of surveys like this in Power BI so please feel free to ask for a more specfic answer.
The choice is yours to which way you want to do this.