Is there a way to code this in a more simple way?

[Anonymous]

Hi, 

I'm working on a simple dashboard and plan to publish this dashboard to the web. My data is an excel sheet uploaded on to OneDrive. From there, it is turned into a Power BI Dataset which I then use to create my reports. 

I'm mostly utilizing four collumns in my data: 1) Date 2) Week Number 3) Task Category and 4) Task Amount. I wanted to create a card visualization on which I can show the total amount of task in the most recent week number. I was able to figure it out by creating a DAX Measure, but because of the complexity of the measure, I'm now unable to publish the dashboard to the web for some reason. 

Here's my DAX Code:

Total Tasks This Week =
CALCULATE(
SUM('Task Tracker'[Task Amount]),
FILTER('Task Tracker', WEEKNUM('Task Tracker'[Date]) = WEEKNUM(MAX('Task Tracker'[Date]),2)
)
)

If anyone here knows of a more simpler way for me to code this that would also allow me to publish the end result on to the web, then I would highly appreciate your help. 

[amitchandak · Accepted solution]

@Anonymous , For this have new columns in a date table

new columns
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

measures
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s