Forum Discussion

jeffw14's avatar
jeffw14
Helper I
4 years ago

Using DAX in a Visual to update column values in a table

I have a Sales and Commission Report/Visual that uses a Date Slicer to present the data within the selected date range. Is there a way  using DAX and a Button (or selection) to update a column in the table for each of the rows presented in the visual to a YES value?

 

I would like to present the commissions to the user in the visual, have them click a Paid Button, and then have the field Comission_Paid updated to a "Yes" value in my Commissions Table for each row presented in the visual.

 

Thank you