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.
Hello Community,
I have 3 sales table with only month and year, and 3 budgeted sales tables with only month and year. how do I create relationship with the date table. I want to calculate the quarterly sales for each year and compare to the each quarterly sales
Each Sales table consists of
Customer
Item
Month
Year
Budget tables also consists of
Customer
Item
month
Year
Thanks Community
Hi
The first thing I would do would be combine the three sales tables into 1 sales table and do the same for budgets.
It should fall into place quite easily after that. Let us know how you go
Cheers
Hello Oliver, When i make a list of year , then i get extra blank list ??? Have any idea ??
You need to show us what you mean
Hi
Can you post an image of the data model?
Cheers
Oliver
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |