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.
Hi Experts,
Is it possible to do the right outer join in the power bi Data model?
SELECT *
FROM attendance a
right outer join student b
on a.student.id=b.studentid
Solved! Go to Solution.
@Anonymous
Refer merge
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If it is dimension side , use show values with no data in Visual
If it is on fact side add +0 to formula
in edit query mode, reverse the steps.
@Anonymous
Refer merge
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If it is dimension side , use show values with no data in Visual
If it is on fact side add +0 to formula
So strictly speaking the data model does not have a LEFT/RIGHT join concept.
But I'm assuming that what you actually want is to show all students regardless of whether they have an attendance record or not. Typically the visuals in Power BI will hide rows that return a blank value so the "trick" is to create a measure that returns a non-blank value. So if you wanted a count of attendance you could do something like the following:
COUNTROWS( Attendance ) + 0
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |