Relate timestamps with uncertainty

[Anonymous]

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...

[v-yuta-msft]

Hi Jan_Orlandini,

Power bi also support calculate column, please refer to this documentation : https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns.

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

of course, I know about that: But still the question remains - what DAX code do I need to make it happen?