Crosspost from How do I do a correlation report on Power BI Desktop - Microsoft Community
Say I'm wanting to take data, and correlate it to each other.
I have thousands of rows I'm importing from MySQL, and what I want to do is see if this serial number pops up again but with a different record type, within a certain amount of time, and then highlight/mark/isolate it.
Here's an example:
Image - https://filestore.community.support.microsoft.com/api/images/a9f95980-7cea-4f59-b1fb-53b81974c4e5?up...
The recordtype of N01 is considered the source of truth, while service is if a service was called for that serial number.
Effectively, I want to see if I'm able to somehow see if that serial number shows up in N01 after the service call was raised (within a 48 hour timespan)
I'm newer to Power BI, so I'm not 100% sure if that is even possible. Any pointers or leads would be great!
Edit1: Does this involve multiple if's nested down, and if so, how would I (for each row) save the date and serial number as variables to be used within Power Query M?
Reply1:
Just wanted to add on, I'm trying with converting the DateTime to epoch, and using 12 hours as an example:
Image - https://filestore.community.support.microsoft.com/api/images/52888ded-51c1-4f7d-9bb2-7d6fb8c3c204?up...
and trying something with this (n01 being another query):
if [RecordType] = "service" then
if [serialnumber] = n01[serialnumber] and n01[datetime] < [Time12HoursAfter]
then "True"
else "False-nestedif"
else "False-rootif"
But this just returns False-nestedif. Is there a way to do a for each in n01?
