Forum Discussion
Unable to create relationships between tables
Hello, I have two tables four tables I am trying to use and create relationships for. 1. Falls table - data table 2. Patient Days table - data table 3. Calendar table - lookup table 4. Loc...
PaulDBrown
Community Champion
Community ChampionIf you don't have an "Units" column in the Patients Fall table you will get this. If you do have a Units column in both tables, you need to create a dimension table for Units too. In fact, you should create dimension tables for all fields common to both tables and use the dimension fields in visuals, slicers, measures, filters...
PaulDBrown I'm confused.
Why would I ge this if I don't have an "issue" column in my patient's fall table? --- which I don't!
I simplified the fields in my tables, I don't have fields that are common to mulptiple tables except the location and date fields but this didn't resolve the issue.