Sales this week

[JSturgeon]

In my dataset, I have 2 years of data by day. I am being asked to produce sales for the current week and need help getting that for the active week I am in. 

Can anyone help me with a simple solution for this?

[VahidDM]

Hi @JSturgeon 

You need to add a Date/Calendar table to your model and add a connection between youe tables and Date table:

To create a Date Table see this: https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

then you need to use WEEKNUM Dax function to find the Week Number of Today:  WEEKNUM(Today())
after that write a dax code to filter the Date table based on the WeekNum and sum the Sale.

Can you Share sample of your data our PBIX file [after removing sensetive data]?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!