Forum Discussion
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
2 Replies
- amitchandakSuper User
jeffw14 , You can not use slicer values in a calculated columns
- AnonymousNot applicable
Hi jeffw14 ,
Please review the content in the following links by using Power Apps and check whether they are what you want.
Power BI Write Back with Power Apps
Power BI write-back functionality with Power Platform services
Best Regards