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.
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
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |