You’re offline. This is a read only version of the page.
Announcements
86
I have a table in Excel that acts as a Q&A form. There are multiple answers in a dropdown list and each answer has a score (each question is also weighted). This is used to calculate a weighted score by multiplying each score by its weight and adding all of that together. Depending on what the answer is, the score would change.
I thought this was easily done in Power BI (with a slicer for the questions and answers and then a data card showing the calculated score) but I ran into issues creating independent slicers on the same page.
Here is an example table that I want to create in Power Apps (with the formula visible for the 'score with weight' cell). Note that the answers are dropdowns.
When I try to do the score with something like "If('DataCard1' = "Good", 4) I get a formula error.
I basically just need to recreate If statements in Power Apps for the score that would be: Very good 5, Good 4, Alright 3, Bad 2, Very Bad 1. And then a final score like in the screenshot above.
The Power Apps documentation isn't very helpful.
Share
Report
All responses (
Answers (
