User Profile
Paul_Cracknell
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Avg Sales Per Week Day using DAX
@Sergei, Thank you. This is giving me the average of each order on those week days. I am looking for the average of the total quantity for each of those weekdays. That's why I tried AVERAGEX because it would sum the quantity for each weekday first, then run the average for each weekday.Avg Sales Per Week Day using DAX
Hi, all. I have a dimension table that is a standard date dimension table - has all the usual elements (date, day of week, week number, month number, etc). I also have a fact table with sales for each date. I am interested in getting the average sales per day of the week. For example, average sold on Monday. Average sold on Tuesday. Etc. I am using: AVERAGEX(VALUES(dCalendar[Day of Week]),[QTY]) but it's producing numbers that don't square with reality. Any other suggestions? PaulAverage Quantity Shipped by Day of Week
Hi, all. I am having a difficult time figuring out how to correctly formulate DAX so I get average quantity shipped per day of week. I am using AVERAGEX(fShipments, [Total Qty]) but I am generating a number that isn't logical. We ship about 100,000 units per week so my per day should be around 17,000. See attached screen shots.Power Query Lookup Table Strategy - Advice Needed
Hi, all. I have a large flat file and I am seeking advice on how to best create lookup tables. Currently, I am cleaning up the flat file and using “Duplicate” to create my lookup tables. This is slowing my model down. Each time I use “Duplicate” to create another lookup table, it takes longer for the model to process the data. This flat file I am working with has 6 different lookup tables. By the time I get to my sixth lookup table, the model is really slow. Is there a better, more efficient way to create lookup tables? I have thought about creating separate queries for the lookup tables and then connecting to the separate files. Any advice would be greatly appreciated. Thanks, Paul
