calculate revenue for current week

[wenners68]

Hi,

I'm trying to find an example of how to sum total sales for the current week.

My dataset includes a date field for each transaction in the format 22/10/2017.

Any ideas?

[v-yuezhe-msft · Accepted solution]

@wenners68,

Create a column using the DAX below in your table.

WeekNumber = WEEKNUM(Table[Date],2)

Then create a measure using the Dax below and check if you get expected result.

SalesforCurrentWeek= CALCULATE(SUM(Table[sale]),FILTER(Table,YEAR(Table[Date])=YEAR(NOW())&&WEEKNUM(NOW())=Table[WeekNumber]))

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@wenners68,

Create a column using the DAX below in your table.

WeekNumber = WEEKNUM(Table[Date],2)

Then create a measure using the Dax below and check if you get expected result.

SalesforCurrentWeek= CALCULATE(SUM(Table[sale]),FILTER(Table,YEAR(Table[Date])=YEAR(NOW())&&WEEKNUM(NOW())=Table[WeekNumber]))

Regards,
Lydia

[Anonymous]

I used this same calculation for counting the number of dates, however, when adding to the table visual, it shows the same count across all jobs.

Is there a way to have each line calculate by job?

[wenners68 · Accepted solution]

Thanks!