Find out total sales for last week per specific day

[Satan]

Hi all, so i'm completely new to DAX/PowerBI and was looking for some guidence. I'm looking to get the sum of all sales throughout my company for last week(excluding sunday) and have the option to select specific days. 

Any ideas?

[v-haibl-msft · Accepted solution]

@Satan

In this scenario, you can create a calculate table to get the expected result. Assume you have a dataset as below.

1. Use following formula to create a table which only includes data of last week.
   

   Table2 = 
   CALCULATETABLE (
       Table1,
       WEEKNUM ( Table1[Date] )
           = WEEKNUM ( TODAY () ) - 1,
       WEEKDAY ( Table1[Date] ) <> 1
   )

2. Create a column to show the weekday.
   

   WeekDay = 
   FORMAT ( Table2[Date], "dddd" )

3. Drag a Slicer (select Table2[WeekDay] for Field) and a Card chart into your canvas.
   

[Satan]

That done the trick, thank you. Regarding the slicer, the days are in a mixed order i.e. Monday, Thursday, Tuesday, Friday etc. Is there anyway i can change this to the correct day format? Monday, Tuesday, Wednesday etc. 

Also there was one more thing i was hoping for some advice on. Is there a way i can list the top selling products by day/week/year?.

Thanks again, Kris and Herbert 🙂

[v-haibl-msft]

@Satan

Please select the column Table2[WeekDay] and click “Sort By Column – Date” as below.

For the top selling products, I think you can try to use the RANKX function. In below screenshot, I rank the total sales in all departments for each day last week.

Best Regards,
Herbert

[a_mixed_life]

I would recommend to have a Date table or Date Filter table. You can achieve that by getting a DateStream from Azure Marketplace. See my post here from another post. Hope that helps!

http://community.powerbi.com/t5/Desktop/How-to-Sort-Months-Chronogically/m-p/50469#M20204