Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
There's already a couple posts on this but didn't find one with my exact issue.
I have 3 tables, one for my projects :
One for the Invoice table
One for the association table between invoice<->projects :
Goal is to get for each client the total time spent on a project with the total amount invoiced like this :
I've been trying to add relationships using PowerBI but it only accepts 1 to N relationships. And as i have :
123 / C001
123 / C002
It doesn't allow me to create it.
I've read in some posts that it could be possible to write a query as a workaround ?
Is that correct ? And do you have any idea of the query that could be used ?
Thanks!
Error i'm getting (french) :
Solved! Go to Solution.
Hi @deanmit,
Here we can enable Composite models to create many to many relationship directly, the many to many feature is available in both July and August release, you can download the new Power BI desktop from here. For more details, please refer to the online document. Also attached the pbix for your reference.
Regards,
Frank
Hi @deanmit,
Here we can enable Composite models to create many to many relationship directly, the many to many feature is available in both July and August release, you can download the new Power BI desktop from here. For more details, please refer to the online document. Also attached the pbix for your reference.
Regards,
Frank
Hello @v-frfei-msft,
Thanks for your reply. I installed latest version, enabled many to many relations in the options and gave it a try !
I just don't get how you have those results. Here's what i get :
qsqsd
Where did you actually put your pbix to see how you did that???
I don't seem to be able to find it :'(
Regards,
Dean
@v-frfei-msft, working
The difference is the 1-1 relationship between "association" and "invoice" table. I had a 1-N.
Thanks a lot for the pbix !
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
104 | |
97 | |
39 | |
30 |