Forum Discussion
Solved
New Table using Latest Distinct Value
Hi! So I have this table that has consolidated list of client and the corresponding sales representative during the period. Client Sales Rep YearMonth A Barney 202001 B Ted 202...
newgirl I think amitchandak works if you create it as a measure, then in a table visual add the Client and the Measure.
Last Sales Rep = LASTNONBLANKVALUE('Table'[YearMonth],max('Table'[Sales Rep]))If you want it as a seperate table, you could also do this:
Table 2 = SUMMARIZECOLUMNS('Table'[Client],"Last Sales Rep",[Last Sales Rep])
newgirl I think amitchandak works if you create it as a measure, then in a table visual add the Client and the Measure.
Last Sales Rep = LASTNONBLANKVALUE('Table'[YearMonth],max('Table'[Sales Rep]))
If you want it as a seperate table, you could also do this:
Table 2 = SUMMARIZECOLUMNS('Table'[Client],"Last Sales Rep",[Last Sales Rep])
