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,
my data is presenting me the sales per article per day per location. Like this.
Location|Date|Article_Nr|Sales
1000 | 05.08.2019 | 100 | 41,92 € |
1000 | 05.08.2019 | 200 | 2,76 € |
1000 | 05.08.2019 | 300 | 5,51 € |
2000 | 05.08.2019 | 100 | 10,00 € |
2000 | 05.08.2019 | 300 | 9,25 € |
3000 | 06.08.2019 | 100 | 28,22 € |
3000 | 06.08.2019 | 200 | 111,59 € |
1000 | 06.08.2019 | 100 | 56,45 € |
There are multiple locations and multiple articles per day. But not each locations will appear each day. And not every article will be sold in every day.
I need a way to Sum up data per Day per location.
I also need to count the days with sales for each location.
My goal is, to achieve average Sales per Day in total, aswell as per location.
I only get a general Average of Sales per Day, which doesnt consider different day-count per location.
Basically distinctcount location for distinct date.
Thx
Solved! Go to Solution.
You can use summarize:
Summarize(Table;
Table[Location];
Table[Date];
"Sum";Sum(Sales);
"AVG";average(Sales))
You can use summarize:
Summarize(Table;
Table[Location];
Table[Date];
"Sum";Sum(Sales);
"AVG";average(Sales))
Thank You,
the pivot-table works just fine
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |