Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Relate timestamps with uncertainty

Dear datanauts,

 

I have trouble relating two datasets:

 

One of which contains my Fact production data (batch ids, start/end dates,  product names etc.) and another carries Fact IssueHandling (with category of incident, start/end date, time lost, solution text etc.)

 

What I'm trying to do is to find back for each incident the name of the product produced during the incident.

Back in Excel I used a "MATCH()", which performed a lookup by comparing the timestamp of the incident notification to the nearest lower timestamp of the production data.

 

But the excel solution is of course a "calculated column"...

 

Is there a way to ´rebuild' this in PowerBI? Preferably as measure, if no other way as calculated column...

 

 

Thanks in advance...