cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jan_Orlandini Frequent Visitor
Frequent Visitor

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Relate timestamps with uncertainty

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

Jan_Orlandini Frequent Visitor
Frequent Visitor

Re: Relate timestamps with uncertainty

Hi Jimmy,

 

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