Forum Discussion
Unique column values
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 ) )
Anonymous just create a dax measure do a LastDate = lastdate(datefield) and use the LastDate
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
Anonymous ok you need to summarzie the table in my opinion
summarizetable = SUMMARIZE(data,Data[Customer #], Data[Sales Rep], "Lastdate", max(Data[Last order date]) )
from the new table you should be abel to pull the last per record
Anonymous
Try this MEASURE.
Then Drag Customer # and this MEASURE to a TABLE visualLastSalesRep = CALCULATE ( SELECTEDVALUE ( TableName[Sales Rep] ), FILTER ( TableName, TableName[Last order date] = MAX ( TableName[Last order date] ) ) )Anonymous