Find the Latest Order date in the selected date range for Tag ID

[NavaneethaRaju]

Hi, 

I want to display the last order date for tag id with in selected date range.

Figure 1: Month MAY

Month : April

with respective of the selected month, should show only one record in a month for a Tag ID's

Please advice , measure or calculated column.

[tamerj1 · Accepted solution]

Hi @NavaneethaRaju 
Please try

Last Order Date =
CALCULATE (
    MAX ( TableName[Order Date] ),
    REMOVEFILTERS (),
    VALUES ( TableName[Tag ID] ),
    ALLSELECTED ( TableName[Order Date] )
)