Forum Discussion
siva54
Helper I
Helper INeed Same values corresponding to ID Column
Hi Team,
I need calculated column based on category and cat Id,
Some category have catid and some not have.
example:- for category "Pen11" have catid"1001" for all "Pen11" catid should be Same. If catId is blank then blank.
You could do it by returning the max catid per category
Result = CALCULATE(MAX('Table'[catid]), ALLEXCEPT('Table', 'Table'[Category]))
1 Reply
PaulOldingSolution Sage
You could do it by returning the max catid per category
Result = CALCULATE(MAX('Table'[catid]), ALLEXCEPT('Table', 'Table'[Category]))