Forum Discussion
PowerBI, if value exist then replicate
you can create below calc column in this case
ManualUpdate =var _tempTab = SUMMARIZE(FILTER(Tab_cust,Tab_cust[DuplicatesCheckAmend]="DuplicateRegistered"),Tab_cust[CustNo],"CountDup",COUNTx(Tab_cust,Tab_cust[DuplicatesCheckAmend]))var _ManualUpdate = if (CONTAINS(_tempTab,Tab_cust[CustNo],Tab_cust[CustNo]),TRUE(),FALSE())return_ManualUpdatepl. try this solution. also whenever you are raising any query, it is advisble to share data that can be copied. I had to convert the image to data.
Community ChampionGoRo2010 in this case you can create a calc colume like below. it will count custNo in the table and if it is more than one then it will give assign true value in the new column else false
Thank you for this negi007 , but I think I might have explained it a bit wrong.
As you can see as per below example, I have 2x (sometimes even more) where the CustNo is the same, but underneath DuplicatesCheckAmend, if one of the values equals to "DuplicateRegistered" between all of the same CustNo (1400083) as per this example, a new column needs to be created where all the values against CustNo (1400083) needs to be true, there might be a case where there is multiple CustNo (9999) as an example but "DuplicateRegistered" does not exist in DuplicatesCheckAmend, those then needs to be false.
Thank You
- negi007
GoRo2010 i guess DuplicateRegistered value will appear only when there are multiple values for same cust_No, in that case you can have simple calc column like below
ManualUpdate = if(Registered_Customers[DuplicateCheckAmend]="DuplicateRegistered",TRUE(),FALSE())in case if this is not what you are looking for, then i suggest you to share sample data in the text format so that we can do testing on the data.
