Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am getting to grips with powerbi, I've done a 7 hour course and clearly have some way to go, so any assistance or pointing to the right direction would be very welcomed. I'm comfortable with Excel.
I have connected to three SQL data views:
1.) Sales - with fields date, amount for each sale client id, year, accounting period (base data)
2.) Fees balance - with fields, client balance, client id, year, accounting period
3.) Client data - with fields, client id, client name, account manager plus other client related fields
In the relationships I have connected them together via the client identifier one client in each case where the one is the client.
Next set up a table with Year & Period from sales, Client Id from client data, fees balance from fees balance.
The result is the balances per period per client are massively over stated.
Help and thank you.
Best wishes
Ros
Solved! Go to Solution.
I created a table with the year and period in - then connected all the other tables to this year and period (many to one) then filtered on this and the problem went away. Seemed to be my data relations. Thank you for your offer to help. Best wishes
Ros
Hi @Ros-ec ,
Can you provide a picture of your model and the result you are getting with some sanitised data?
Thanks,
Did I help you today? Please accept my solution and hit the Kudos button.
I created a table with the year and period in - then connected all the other tables to this year and period (many to one) then filtered on this and the problem went away. Seemed to be my data relations. Thank you for your offer to help. Best wishes
Ros
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |