How do I set up relationships between two tables?

Asked Viewed 32 times Solved
0

I have Sales and Countries tables. How do I join them so I can see sales by region?

Connectors and data DAX and Transform AI Insights 365 Team

1 answer

0
Accepted answer

Open Model & relationships in Report Studio, drag the key column from one table onto the matching column in the other, and choose the direction. Charts can then use fields from both.

More detail: Report data model

AI Insights 365 Team ·

Your answer

Know the answer? Sign in to help. It's free.