Create a column when different rows have the same value

[Adrian_rev]

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

[BIswajit_Das · Accepted solution]

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 requirement

Thanks & Regards...

[pankajnamekar25 · Accepted solution]

Hello @Adrian_rev ,

try this

New_Family_ID =

CALCULATE (

    MAX (YourTable[FAMILY_ID]),

    ALLEXCEPT (YourTable, YourTable[INVOICE])

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[BIswajit_Das · Accepted solution]

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 requirement

Thanks & Regards...

[Adrian_rev]

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

[BIswajit_Das]

Hello @Adrian_rev 
If you've share some demo data with required result column it would be easy to understand your requirement.
Thanks & Regards ...