Forum Discussion
Solved
PowerBI, if value exist then replicate
Good Day, I am looking for a DAX command, as per example below, I have been able to identify duplicate email addresses ect, what I need assistance with is to say, if CustNo "1400083" as per this ...
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.
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
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
_ManualUpdate
pl. 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.