dax average
2 Topics
Average Per day
I have done a bit of search in the forum & couldn't find scenario matching with one that I have got, hence this post. Scenario here is if I am running Daily/Magazine distribution centre and delivering them directly to my subscribers as per the below annexed table.. I would like to ascertain the below : a) Average minutes taken per day (composite of Dailies, Weeklies & Monthly) Description Category Frequency Time taken (in Mins) Days Total time consumed per day (Time Taken (in Mins) <divided by> Days) The New York Times Newspaper Daily 50 1 50.00 USA today Newspaper Daily 30 1 30.00 Chicago Tribune Newspaper Daily 20 1 20.00 The Wall Street Journal Newspaper Daily 40 1 40.00 The Washington Post Newspaper Daily 35 1 35.00 Cosmopolitan Magazine Weekly 120 7 17.14 Sports illusrated Magazine Weekly 75 7 10.71 People Magazine Weekly 60 7 8.57 Los Angeles Times Magazine Weekly 110 7 15.71 National Geographic Books Monthly 180 30 6.00 Vanity Fair Books Monthly 110 30 3.67 Golf Magazine Books Monthly 140 30 4.67 20.12Solved2.4KViews0likes1Comment
Average by Product and Week Type
Hello Team, I apologize if this question has already been addressed, but I haven't been able to find a solution. I've been struggling with this issue for the past couple of days and it's causing me quite a headache. Could you please assist me in achieving the result in the last column using either a measure or a column? Thank you in advance for your assistance. Product Weeks WEEK TYPE Price Sales Average per Product on SHELF WEEK AB 21-Oct-24 SHELF $10.0 10,000 10,000 AB 28-Oct-24 SHELF $10.0 10,000 10,000 AB 18-Nov-24 PROMO $5.0 20,000 10,000 BB 21-Oct-24 SHELF $8.0 40,000 40,000 BB 28-Oct-24 SHELF $8.0 40,000 40,000 BB 18-Nov-24 PROMO $4.0 80,000 40,000Solved860Views0likes4Comments