Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Adrian_rev
New Member

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

2 ACCEPTED SOLUTIONS
BIswajit_Das
Super User
Super User

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])
)
pbic.png
Please Let me know if this isn't meet your requirement
Thanks & Regards...

View solution in original post

pankajnamekar25
Super User
Super User

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.

View solution in original post

4 REPLIES 4
pankajnamekar25
Super User
Super User

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
Super User
Super User

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])
)
pbic.png
Please Let me know if this isn't meet your requirement
Thanks & 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 ...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.