Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
6 years ago
Solved

earlier function combine with other columns

Hi,   I have a table as below.  Column uses  "Column = VAR _count= CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[salesman/country]=EARLIER('Table'[salesman/country])&&'Table'[Index]>=EAR...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    selpaqm , refer this can work as a new column

    Column =
    VAR _count= CALCULATE(DistinctCount([Method]) ,FILTER('Table','Table'[salesman/country]=EARLIER('Table'[salesman/country])))+0
    return if(_count>1,"Mixed", [method])