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])

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

selpaqm First, DAX Formatter is your friend: https://www.daxformatter.com/

 

Column =
  VAR __Table = 
    SUMMARIZE(
        FILTER (
            'Table',
            'Table'[salesman/country] = EARLIER ( 'Table'[salesman/country] ),
            [method]
        )
RETURN
    IF ( COUNTROWS(__Table>1, "mixed", MAXX(__Table,[method]) )

If not, share data as text in a table please. 

  

  • selpaqm's avatar
    selpaqm
    Helper V
    5 years ago

    hi Greg_Deckler 

    unfortunately, taken error.

     

    Example.pbix 

    at above link you may find my find pbix file.

     

    Regards,

    • 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])