Forum Discussion
Creating a conditional column based on a fluctuating value
Hi there! I am having trouble getting a new conditional column on my Power BI Dashboard. I have the following columns in my data: - Name and Surname of individuals - Question (one per row...
Anonymous have you done an unpivot/ multiple tables to clean the data model first? See my webinar on survey data transformations if it helps: https://www.excelwithallison.com/MCT/news
Once you have the data model cleaned, you should be able to use a variable within calculated column to find THIRD and then use SWITCH (rather than nested IFs) to get what you need.
Anonymous have you done an unpivot/ multiple tables to clean the data model first? See my webinar on survey data transformations if it helps: https://www.excelwithallison.com/MCT/news
Once you have the data model cleaned, you should be able to use a variable within calculated column to find THIRD and then use SWITCH (rather than nested IFs) to get what you need.