New to Power BI - Creating Tables

[jamesfbeard]

Hi all,

Looking for some advice for someone relatively new working with PBI. I have some data coming from a database and have a column with categorical data, i.e. "Apple", "Banana", "Broccoli". If I wanted to create a new grouping for this data based on this data, what would best pratice, a seperate reference table help offline or a table stored in Power BI which i can link the data to?

Data Field	Reference Grouping
Apple	Fruit
Banana	Fruit
Broccoli	Vegetable
Grape	Fruit

[Kedar_Pande · Accepted solution]

@jamesfbeard 

1. If your grouping is frequently changing or needs to be managed by others, go with the reference table (option 1).
2. If your grouping is static or has very few changes, you can manage it directly in Power BI with an internal table (option 2).

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn