Forum Discussion
Create a column when different rows have the same value
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.
Hello Adrian_rev
You can create a calculated column with the below DAX;
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 ...