Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 example have the Value underneath DuplicateCheckAmended = "DuplicateRegistered" to create a new colomb with the label "ManualUpdate" with the value "True" on all line items where CustNo is the PK (1400083).
This is my current coding to identify if a customer has registered before or not.
Thank You
Solved! Go to Solution.
you can create below calc column in this case
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.
Proud to be a Super User!
you can also do this:
@GoRo2010 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
Proud to be a Super User!
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
@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
Proud to be a Super User!
@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
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.
Proud to be a Super User!
@negi007 , you are a legend. Thank you for this, this has resolved my query. Have a blessed year and a merry xmas!
@negi007 , I need this replicated with true across all CustNo where CustNo = CustNo.
I will create a demo excel sheet now for you. Tnx
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |