Forum Discussion
Find Recent date for respective column
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.
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])
4 Replies
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])
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.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.
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.
