Forum Discussion
Solved
Retrieve data from related table with filter conditions
My current data structure has a relationship where our Client Database which holds key information (name, dob etc) is the central node and various other tables of data relate to this via a "ClientRec...
Update- I believe I have managed to sort the issue with the below DAX query:
LastEDEQScore = var clientRecordID = 'Online Referral Form Responses'[ClientRecordId] var fromDate = 'Online Referral Form Responses'[Created] var results = MAXX(filter('EDE-Q 6 0 Form Responses','EDE-Q 6 0 Form Responses'[ClientRecordId] = clientRecordID && 'EDE-Q 6 0 Form Responses'[Created] >= fromDate),'EDE-Q 6 0 Form Responses'[Id]) var record = MAXX(Filter('EDE-Q 6 0 Form Responses', 'EDE-Q 6 0 Form Responses'[Id] = results),'EDE-Q 6 0 Form Responses'[GlobalEDEScore]) return recordSeems to be working as intended!
Update- I believe I have managed to sort the issue with the below DAX query:
LastEDEQScore = var clientRecordID = 'Online Referral Form Responses'[ClientRecordId] var fromDate = 'Online Referral Form Responses'[Created] var results = MAXX(filter('EDE-Q 6 0 Form Responses','EDE-Q 6 0 Form Responses'[ClientRecordId] = clientRecordID && 'EDE-Q 6 0 Form Responses'[Created] >= fromDate),'EDE-Q 6 0 Form Responses'[Id]) var record = MAXX(Filter('EDE-Q 6 0 Form Responses', 'EDE-Q 6 0 Form Responses'[Id] = results),'EDE-Q 6 0 Form Responses'[GlobalEDEScore]) return record
Seems to be working as intended!