Forum Discussion
Solved
Family Household Completion
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 ...
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:
Column = CALCULATE(SUM(panrets[Status]))
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:
Column = CALCULATE(SUM(panrets[Status]))