Video: Determing the punctiation of an item based on its position in a list with Power Query
Van: Celia Alves - Solve & Excel
Duur: 9:17
Bij Microsoft Forms krijgt eerste antwoord meeste punten, laatste antwoord minste punten. Hoe verwerk je dat mbv. Power Query. Splits tekst in rijen ipv kolommen
One Form for a poll contained a question asking the users to sort three items by the order of their preference. To determine the winner item, we will attribute 3 points every time the item is chosen in first place, 2 points when it is chosen in second place and 1 point when it is chosen in third place. We will use Power Query to implement this calculation method and determine the winner.
Functies: -
