Forum Discussion
Basic Power BI Question with Google Analytics
kaushikd I think it is the second problem. I want to use date as the primary key to join but I do not see where in the web interface to make this connection. Any idea??
Thanks!
While creating relationship make sure that both the datasets have keys to join(Table A and Table B both should have datekey)
or do one thing pick the date for the main table itself from which you are picking other measures like(Sessions, views etc)
I do have date in both of the tables but I do not see where i can create a relationship. Am i missing somehting on the interface?
Perfect In your case as I see your two tables (Daily Users and Site Overview) both have date field in it so basicly these are Fact Tables now you have to create a Dimension table for date( DimDate) and then join the DimDate-->Date field with Daily Users-->Date and Site Overview-->Date.
Please Follow the steps:-
1.Go to Data Tab and in modelling tab select new table
Put the code as shown in the fig to create the DimDate
DimDate = CALENDAR (DATE (2010, 1, 1), DATE (2017, 12, 31))
2. Go to the Relationship mode and join DimDate table with both tables(Daily Users and Site Overviews)
It will look somehow like
Now in the table select Date field from DimDate table,Users from Daily User table and AvgSession from Site Overview table.
Hope this will short out your problem.