Forum Discussion

minhvuong93's avatar
minhvuong93
Icon for Helper II rankHelper II
8 years ago

Sum averages with filters

Hello everyone, I have a dataset of monthly customer invoice by region , like this:   Region _ Customer _Product_OrderQuantity_Month A         _   Customer 1 _ Product 1__100_____Jan A       _  ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

I think i have solved it.  You may download the file from here.

 

minhvuong93's avatar
minhvuong93
Icon for Helper II rankHelper II
8 years ago
DATESYTD('Calendar'[Date]))

HI Ashish_Mathur,

Big thanks for your support,

I have a question regarding the Total Sales YTD .

 

Total sales volume (YTD) = CALCULATE([Total sales volume],DATESYTD('Calendar'[Date]))

 

I am not sure what the DATESYTD(Calendar[Date]) does but I assume that when a Month in Calendar table is selected, the sales volume is aggregated from the START DATE to END DATE of the month,

 

With the current file you sent me, I can see that when I select January, the YTD Volume became lower vs Feb. However I still want to see the YTD volume = total of Jan + Feb when getting the AVerage Vol per Outlet

 

Sorry for not mention this, but what I would like to accomplish is: Total Average Vol per outlet = Sum YTD Average of volume of Existing Outlets in that Month,

 

 

Thanks so much,

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    This is thoroughly confusing now.  When you select Jan, YTD will be for Jan only.  Why should Feb be included?

  • minhvuong93's avatar
    minhvuong93
    Icon for Helper II rankHelper II
    8 years ago

    Ashish_Mathur

    Sorry for this confusion,

    I want to see the volume to be yearly average to see the full potential sales of the outlets.

    Your file work for me though. 

     

    Now it is a matter of the count products bought and the average....

     

    let me see if I can figure this out ,:)

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Sure.  Try the count.  If you face a problem post back.