topic Average Per day in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Per-day/m-p/3937860#M153139 <P>I have done a bit of search in the forum &amp; couldn't find scenario matching with one that I have got, hence this post.</P><P>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 :</P><P>a) Average minutes taken per day (composite of Dailies, Weeklies &amp; Monthly)</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Description</TD><TD>Category</TD><TD>Frequency</TD><TD>Time taken (in Mins)</TD><TD>Days</TD><TD>Total time consumed per day<BR />(Time Taken (in Mins) &lt;divided by&gt; Days)</TD></TR><TR><TD>The New York Times</TD><TD>Newspaper</TD><TD>Daily</TD><TD>50</TD><TD>1</TD><TD>50.00</TD></TR><TR><TD>USA today</TD><TD>Newspaper</TD><TD>Daily</TD><TD>30</TD><TD>1</TD><TD>30.00</TD></TR><TR><TD>Chicago Tribune</TD><TD>Newspaper</TD><TD>Daily</TD><TD>20</TD><TD>1</TD><TD>20.00</TD></TR><TR><TD>The Wall Street Journal</TD><TD>Newspaper</TD><TD>Daily</TD><TD>40</TD><TD>1</TD><TD>40.00</TD></TR><TR><TD>The Washington Post</TD><TD>Newspaper</TD><TD>Daily</TD><TD>35</TD><TD>1</TD><TD>35.00</TD></TR><TR><TD>Cosmopolitan</TD><TD>Magazine</TD><TD>Weekly</TD><TD>120</TD><TD>7</TD><TD>17.14</TD></TR><TR><TD>Sports illusrated</TD><TD>Magazine</TD><TD>Weekly</TD><TD>75</TD><TD>7</TD><TD>10.71</TD></TR><TR><TD>People</TD><TD>Magazine</TD><TD>Weekly</TD><TD>60</TD><TD>7</TD><TD>8.57</TD></TR><TR><TD>Los Angeles Times</TD><TD>Magazine</TD><TD>Weekly</TD><TD>110</TD><TD>7</TD><TD>15.71</TD></TR><TR><TD>National Geographic</TD><TD>Books</TD><TD>Monthly</TD><TD>180</TD><TD>30</TD><TD>6.00</TD></TR><TR><TD>Vanity Fair</TD><TD>Books</TD><TD>Monthly</TD><TD>110</TD><TD>30</TD><TD>3.67</TD></TR><TR><TD>Golf Magazine</TD><TD>Books</TD><TD>Monthly</TD><TD>140</TD><TD>30</TD><TD>4.67</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20.12</TD></TR></TBODY></TABLE> Wed, 22 May 2024 04:39:48 GMT qv 2024-05-22T04:39:48Z Average Per day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Per-day/m-p/3937860#M153139 <P>I have done a bit of search in the forum &amp; couldn't find scenario matching with one that I have got, hence this post.</P><P>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 :</P><P>a) Average minutes taken per day (composite of Dailies, Weeklies &amp; Monthly)</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Description</TD><TD>Category</TD><TD>Frequency</TD><TD>Time taken (in Mins)</TD><TD>Days</TD><TD>Total time consumed per day<BR />(Time Taken (in Mins) &lt;divided by&gt; Days)</TD></TR><TR><TD>The New York Times</TD><TD>Newspaper</TD><TD>Daily</TD><TD>50</TD><TD>1</TD><TD>50.00</TD></TR><TR><TD>USA today</TD><TD>Newspaper</TD><TD>Daily</TD><TD>30</TD><TD>1</TD><TD>30.00</TD></TR><TR><TD>Chicago Tribune</TD><TD>Newspaper</TD><TD>Daily</TD><TD>20</TD><TD>1</TD><TD>20.00</TD></TR><TR><TD>The Wall Street Journal</TD><TD>Newspaper</TD><TD>Daily</TD><TD>40</TD><TD>1</TD><TD>40.00</TD></TR><TR><TD>The Washington Post</TD><TD>Newspaper</TD><TD>Daily</TD><TD>35</TD><TD>1</TD><TD>35.00</TD></TR><TR><TD>Cosmopolitan</TD><TD>Magazine</TD><TD>Weekly</TD><TD>120</TD><TD>7</TD><TD>17.14</TD></TR><TR><TD>Sports illusrated</TD><TD>Magazine</TD><TD>Weekly</TD><TD>75</TD><TD>7</TD><TD>10.71</TD></TR><TR><TD>People</TD><TD>Magazine</TD><TD>Weekly</TD><TD>60</TD><TD>7</TD><TD>8.57</TD></TR><TR><TD>Los Angeles Times</TD><TD>Magazine</TD><TD>Weekly</TD><TD>110</TD><TD>7</TD><TD>15.71</TD></TR><TR><TD>National Geographic</TD><TD>Books</TD><TD>Monthly</TD><TD>180</TD><TD>30</TD><TD>6.00</TD></TR><TR><TD>Vanity Fair</TD><TD>Books</TD><TD>Monthly</TD><TD>110</TD><TD>30</TD><TD>3.67</TD></TR><TR><TD>Golf Magazine</TD><TD>Books</TD><TD>Monthly</TD><TD>140</TD><TD>30</TD><TD>4.67</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20.12</TD></TR></TBODY></TABLE> Wed, 22 May 2024 04:39:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Per-day/m-p/3937860#M153139 qv 2024-05-22T04:39:48Z Re: Average Per day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Per-day/m-p/3937881#M153140 <P>Hi,</P> <P>I am not sure how your semantic model looks like, but please try something like below.</P> <P>I tried to create a sample pbix file like the attached file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">expected result measure: = AVERAGEX(Data, DIVIDE(Data[Time taken (in Mins)], Data[Days]) )</LI-CODE> Wed, 22 May 2024 04:53:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Per-day/m-p/3937881#M153140 Jihwan_Kim 2024-05-22T04:53:42Z