topic Re: Find the Latest Order date in the selected date range for Tag ID in DAX Commands and Tips

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

NavaneethaRaju — Tue, 16 Aug 2022 05:31:10 GMT

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 — Tue, 16 Aug 2022 06:37:16 GMT

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