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.
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
Community ChampionGoRo2010 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
negi007 , here is an example of what I am trying to replicate, because CustNo 1400083 has the value of "DuplicateRegistered" all values in ManualUpdate needs to be true, as per example, CustNo 999999 does not have that value in DuplicatesCheckAmended thus all CustNo 999999 needs to be false, I hope this explains it better.
Thank You
- negi007
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.