Forum Discussion

siva54's avatar
siva54
Icon for Helper I rankHelper I
4 years ago
Solved

Need 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 Sam...
Need Help
  • PaulOlding's avatar
    PaulOlding
    4 years ago

    You could do it by returning the max catid per category

    Result = CALCULATE(MAX('Table'[catid]), ALLEXCEPT('Table', 'Table'[Category]))
PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
4 years ago

You could do it by returning the max catid per category

Result = CALCULATE(MAX('Table'[catid]), ALLEXCEPT('Table', 'Table'[Category]))