Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Unique column values

Hi    I am trying to get a table wth cst and sales rep based on the last order date   so I have a table  Customer # Sales Rep Last order date 1018574 tim 9/21/2017 1018574 alex 9/...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    As a calculated column you could use

     

    Column =
VAR MyMax =
    CALCULATE (
        MAX ( TableName[Last order date] ),
        ALLEXCEPT ( TableName, TableName[Customer #] )
    )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( TableName[Sales Rep], 1 ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Customer #] ),
            TableName[Last order date] = MyMax
        )
    )
vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

Anonymous just create a dax measure do a LastDate = lastdate(datefield) and use the LastDate

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanx vanessafvg

 

That doesnt work because i have multiple sales reps per customer. 

Example customer

1015970 was maintained by sales rep maria in sept 2017, by tom in december 2017, by lisa on the 11th of Jan and finaly by Tom on 15th of Jan 2018

 

I would like to see only TOM

 

Thats why i am trying to get a column where i will see the last date per customer and then use it in another column where i would liek to use if function or something like that.. 

 

would be great if you can help me somehow becasue i am really strugeling here.. 

 

thanx for your time