Forum Discussion
unable to update row data - conditional column
Hi, I am trying to update conditional column row data based on calculation. below is my sample data. need to display certain catagories data as issue for all entries fort he same id, if one ent...
jpat1234 - So what are we looking at? Is that your expected output? If so, what does the source data look like?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
1) for catagory 104 in my table - want to change row level data on issues column
2) for catagory 104 , if one row has issue or follow up then all rows for should be displayed as issue/followup for same id.
3) all other data remains the same.
My data ID category answer followup skipped good Fup Skip Issue 2005 104 90000000 False False 1 2005 104 90000000 False False 1 2005 104 90000000 False False 1 2005 104 80000001 False False 1 2005 56 80000001 True False 1 2006 123 80000001 FALSE False 1 2006 123 90000000 False False 1 Expected data (want to change the way issue column looks in the data table) ID category answer followup skipped good Fup Skip Issue 2005 104 90000000 False False 1 2005 104 90000000 False False 1 2005 104 90000000 False False 1 2005 104 80000001 False False 1 2005 56 80000001 True False 1 2006 123 80000001 FALSE False 1 2006 123 90000000 False False 1
