Apocalipia
New Member
- Joined
- Jan 25, 2012
- Messages
- 10
I have data in the format below (minus the far right column)
Using DAX, I'd like to know if it is possible to add the far right column above. So, if all Complete values are true (grouped by EmailAddress), then the value in AllComplete should be true.
Is this possible, and if so, could an explanation be given as to how?
Thanks in advance
EmailAddress | CourseTitle | Complete | AllComplete |
1@1.com | Course1 | true | false |
1@1.com | Course2 | true | false |
1@1.com | Course3 | false | false |
2@1.com | Course1 | true | true |
2@1.com | Course2 | true | true |
2@1.com | Course3 | true | true |
Using DAX, I'd like to know if it is possible to add the far right column above. So, if all Complete values are true (grouped by EmailAddress), then the value in AllComplete should be true.
Is this possible, and if so, could an explanation be given as to how?
Thanks in advance