Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional relationship for multiple tables

Hi,    I have 4 tables    logins, ConnectedUsers,FacilityCode, ProviderCode.      Basically in ConnectedUsers table i have:  Provider_Name System_Code Facility_Code RegisteredUsers AH...
CALCULATE
COUNT
lbendlin's avatar
lbendlin
Super User
5 years ago

You can't do that in DAX but you can merge tables in PowerQuery based on fuzzy logic like yours. Look at the custom Column Generator function in Table.AddColumn() .