Forum Discussion

PhilC's avatar
PhilC
Resolver I
3 years ago

Data model advice - data table with fields with multiple values

Am after advice about setting up a data model where there are multiple fields that could have multiple values.   Situation is a data (fact) table for publications.  Each publication has a number of...
Need Help
PhilC's avatar
PhilC
Resolver I
3 years ago

Thanks DataInsights 

 

Am digesting this to see if I can implement it.

 

I am not understanding the AuthorGroup table.  I have a unique value for Author.  Where does the Author Group Key in teh Author Group table come from?

 

Thanks

DataInsights's avatar
DataInsights
Super User
3 years ago

PhilC,

 

You would have to build the AuthorGroup table, preferably as part of an ETL process. Do you have access to an ETL developer or are you building this from scratch in Power BI?