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.
I am sure this must be straightforward, but I'm struggling today!
I have two tables, one with parent data pertaining to completing a form, and one with their children. I need to quickly identify for every child if at least one parent completed the form and similarly, a child with no parent completing the form. My data is set into two tables as follows:
Parent
Status | User Id | First Name | Last Name | User ID1 |
Not Started | 123456 | Kevin | Smith | 1 |
Submitted | 654321 | Cynthia | Lee | 1 |
and Students
User ID1 | First Name1 | Last Name1 | Grad Year |
1 | Catherine | Smith | 2021 |
Solved! Go to Solution.
I had a moment of insight (which was sorely lacking yesterday): I transformed the text data into 1 for complete, 0 for incomplete, converted to a number (an easy oversight, as the transform, doesn't change the type), and created the following calculated column in the student table:
I had a moment of insight (which was sorely lacking yesterday): I transformed the text data into 1 for complete, 0 for incomplete, converted to a number (an easy oversight, as the transform, doesn't change the type), and created the following calculated column in the student table:
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |