Forum Discussion

Adrian_rev's avatar
Adrian_rev
New Member
1 year ago
Solved

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, i...
Need Help
  • BIswajit_Das's avatar
    BIswajit_Das
    1 year ago

    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's avatar
    pankajnamekar25
    1 year ago

    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.

Adrian_rev's avatar
Adrian_rev
New Member
1 year ago

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's avatar
BIswajit_Das
Impactful Individual
1 year ago

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