Forum Discussion
Create a column when different rows have the same value
Hello everyone,
I have a table with invoices and information about it. For some of them I have a column which states the family_ID of it. Now I need that for every invoice with the same number, if one of them has the family_ID all the invoices with the same number have it too.
INVOICE FAMILY_ID
2400004561 245641
2400004561
2400004561
These would be the twoo columns, so if I have that for the invoice 2400004561 one of the rows has the family_ID of 245641 I want that for every 2400004561 invoice to have the family_ID 245641.
Thanks in advance,
Adrian
Hello Adrian_rev
You can create a calculated column with the below DAX;RESULT =CALCULATE(MAX('table_name'[FAMILY_ID]),ALLEXCEPT('table_name','table_name'[INVOICE]))Please Let me know if this isn't meet your requirementThanks & Regards...Hello Adrian_rev ,
try this
New_Family_ID =
CALCULATE (
MAX (YourTable[FAMILY_ID]),
ALLEXCEPT (YourTable, YourTable[INVOICE])
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
4 Replies
Hello Adrian_rev
You can create a calculated column with the below DAX;RESULT =CALCULATE(MAX('table_name'[FAMILY_ID]),ALLEXCEPT('table_name','table_name'[INVOICE]))Please Let me know if this isn't meet your requirementThanks & Regards...Thanks in advance,
The problem is that it tells me that there is not a unique value for Family_ID. I might have ten invoices with the same number and two of them have the same family_ID but not the rest. And I would like to have all 10 of them with the same Family_ID.
Best regards,
Adrian
Hello Adrian_rev
If you've share some demo data with required result column it would be easy to understand your requirement.
Thanks & Regards ...
Hello Adrian_rev ,
try this
New_Family_ID =
CALCULATE (
MAX (YourTable[FAMILY_ID]),
ALLEXCEPT (YourTable, YourTable[INVOICE])
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
