Get first date a value from another column exists

Hi eg1230 

there a couple of things that make the answer difficult

1 - you should use a calendar table as a dimension

2 - it seems to me you have a relationship between two facts, you should never connect facts between them but connect them through dimensions

3 - you seem to have the automatic date time active, it is a best practice to deactivate it (so you use a calendar table dimension)

Can you share the pbix so I fix a couple of things and maybe at the same time I solve the measure issue?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI