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.

[Dhacd]

Hi @NavaneethaRaju ,

Just write a max measure.

LastOD= max(table[Order Date])

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.

Thanks and Regards,
Atma.

[NavaneethaRaju]

Hi @Dhacd ,

I used your measure its working fine. thank you. 
And one more issue, i want to show the account name. while using account name from separate table(Account Dim) again its showing all the dates and data. 

Actutally it should show only these marked three.

This is the relationship, Please advice as soon as you can.

[Dhacd]

Is the bidirectional relationship required there for any reason?
can you try changing the flow from account details to the fact table?

Regards,

Atma.

[NavaneethaRaju]

Hi @Dhacd ,

I tried both and single directional, its not showing exactly on that date which account has used. is there any way to find the dynamic ranking - like respective of selected date which the max order date, we ranking from 1 to end and can we apply filter 1 in visual level. 
I have a idea, but i'm not good in ranking measures.

[Dhacd]

@NavaneethaRaju 
You can restrict it with measures. If it is okay can you share the pbix by using wetransfer.com
So that I can take a look.