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.
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.
