Connecting fact tables to dimensions via grouping or Power Query?

[Anonymous]

Dear Community, 

I currently have the pleasure of creating a datamodel from scratch, and would therefore like to do it with the current best practices.

The situation is the following:

I have a column called "device_category" in 2 different tables (social media data). I would like to have them both be able to connect to a device dimension, with 2 values: "Smartphone" and "Tablet".

Table A contains the 2 distinct values: "Smartphone" and "Tablet".

Table B contains the 4 distinct values: "android_phone", "iphone", "android_tablet" and "ipad".

Here's the question:

Should I make a column in Power Query for table B, or make a grouping of the values that match, or something else?

An explaination of your suggestion would be much appreciated. 

Best regards

Andreas

[amitchandak · Accepted solution]

@Anonymous , Create a column in table B first using if in power query

if [Col] = "android_phone" or [Col] = "iPhone" then "Smartphone" else "Tablet"

Now create a table with these two values (using power query , add as new query or edit data or distinct in dax)

and join with both the tables and use