Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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])
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |