Find Recent date for respective column

[NavaneethaRaju]

Hi,

I need to find the recent date for respective column. 

Tag_ID- TagUsageFact(Table)

Tag_Owner_Name= TagUsageFact(Table)

Order_Owner_Name= TagUsageFact(Table)

Order_date= Sales_Fact(Table)

KIndly advice about the measure, how can we find the recent date for respective column.

[v-yalanwu-msft]

Hi， @NavaneethaRaju ；

You could create a measure or column.

MAX_date = CALCULATE( LASTDATE('Table'[ORDER_ DATE]),ALL('Table'))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@NavaneethaRaju , based on what I got you can get a column like this from the same table

new column on TagUsageFact

maxx(filter(TagUsageFact, [Tag_Owner_Name] =earlier([Tag_Owner_Name]) && [Tag_Owner_Name] = earlier([Tag_Owner_Name])),[Order Date])

new column on TagUsageFact

using different table

maxx(filter(Sales_Fact, Sales_Fact[Tag_Owner_Name] =(TagUsageFact[Tag_Owner_Name]) && Sales_Fact[Tag_Owner_Name] = (TagUsageFact[Tag_Owner_Name])),Sales_Fact[Order Date])

[NavaneethaRaju]

Hi @amitchandak , 
I think the syntax might be wrong, i tried that to create a column its not working, and one more thing, i dont have tag_owner_ name in sales fact table, sales fact table only have order date. Please advice me to figure it out.

[NavaneethaRaju]

Hi @amitchandak ,

I need help. 
I created this measures to find max order date for particular tag ID- 
Max OrderDate = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID] ),'Tag Usage Fact'[Date DD/MM/YYYY])

but i want the same to react with the date slicer.

I want the max date for particular tag id between that date range. 

Please advice.