title: Conditional Statements in Power BI: Help greatly appreciated
body: <p>I would be very grateful for any assistance on solving the below.</p>
  <p>I have a table in Microsoft Power BI Desktop containing 2 types of columns: 1 column containing unique employee IDs (column labeled &quot;Employee ID&quot;), and several other columns marking the date when (if ever) an individual completed a specific task (columns labeled &quot;Task 1,&quot; &quot;Task 2,&quot; &quot;Task 3,&quot; etc.).  If an employee completes a given task, s/he receives a bonus.</p>
  <p>Using Power BI Desktop, what is the best way to accomplish the following objectives:</p>
  <p>(1) Assign a numerical value to the completion of each of these tasks/columns (i.e., the bonus), such that future business users (read: non-developers) can adjust the value/bonus as it changes year to year.</p>
  <p>(2) Allow business years to manually enter (a) an employee ID and (b) a fiscal year (e.g., 2021), with the result that Power BI determines whether that employee completed any of the tasks within that fiscal year, and returns the sum total of the values assigned above for all those tasks/columns.</p>
  <p>Thank you very much for your assistance! = )</p>