Forum Discussion

selpaqm's avatar
selpaqm
Helper V
5 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
    5 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])

amitchandak's avatar
amitchandak
Super User
5 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])