Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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
Hi Jimmy,
of course, I know about that: But still the question remains - what DAX code do I need to make it happen?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |