Dax Time Intelligence how to calculate current week Sales

0
votes

I Would like to to calculate this week sales using DAX(Current week sales) (Latest week) Starting from Monday to the latest day of the current week/latest week.

I have attached pbix file https://app.box.com/s/ah11tcvbq45rlc5pujunxkfloyd4x7cu

Total Sales $392enter image description here

2
powerbidax

2 Answers

1
votes

A simple WTD measure would look something like this:

Sales WTD = 
    calculate(sum(CountrySales[Sale]),
                    filter(all('Date'), 'Date'[Date] <= max('Date'[Date]) 
                                     && 'Date'[WeekNum] = max('Date'[WeekNum])))

You can read all about the calculate function online, watch videos, and there's a whole chapter devoted to it in The Definitive Guide to Dax.

1
votes

Create a new visual table, drag your WeekNum and Sale in the table. Select the combobox of the Weeknum and select: Don't summarize. End result as below:

enter image description here