Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I'll try to explain my problem with PowerBI.
I have 2 different datasets; dataset A is from incident management application, with unique incidentID. Dataset B is from project management application, where most (97%) of records have incidentID but few of them are null.
When I'm making report for customers, I need data from both application to create overall full-scale report, but also I need records with null incidentID from dataset B because they are also in scope, and have to be reported.
Is the only way to get this: import A and double B dataset, make a relationship A with B, and then add visuals from related A-B and separatey from non-related B?
Thanks in advance,
Petra
Solved! Go to Solution.
Please refer to this blog for the solution.
It will show you how you can handle null values in the PowerBI using PowerQuery.
Thanks & Regards,
Bhavesh
Please refer to this blog for the solution.
It will show you how you can handle null values in the PowerBI using PowerQuery.
Thanks & Regards,
Bhavesh