Forum Discussion
Find 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])
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.