To find "Last Date" based on a condition

[sshiny]

Need a measure to calculate the "order date" after the "missing since" date. Currently, I am using MAXX function-

Last Order Date = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID] && 'Tag Usage Fact'[Order Date]>'Consignment Fact'[Missing Since] ),'Tag Usage Fact'[Order Date])

I need to avoid the below occurence in the report-where the last order date is less than the missing since date

[Anonymous]

Hi  @sshiny ,

What is the relationship between the two tables of Tagusagh Fakt and 'Consigement Fakt'

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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

[sshiny]

@amitchandak