CALCULATE LAST WEEK

Question

HI,&nbsp; I have a table with a date, I need to count teh ids of teh las week , from de same table:Code:last app = CALCULATE(COUNT(TableID]),Table[STATUSTO] = “apr”, WEEKNUM(Table[DATECREATE],2) = WEEKNUM(MAX(Table[DATECREATE]),2))&nbsp;Error: A "MAX" function has been used in a True /False expession than is unsed as a table filter expression ..Thanks&nbsp;

amitchandak · Answer

driank , refer to my blog, how can use week and week rank for the same. You need to have date /week table with Rank of week start date or Year week 
&nbsp;
&nbsp;
Power BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123https://www.youtube.com/watch?v=pnAesWxYgJ8

Forum Discussion

CALCULATE LAST WEEK

1 Reply

Related content

Week Start calculation

Calculate change % week on week duration

Calculate previous week values

Calculating the week number

Calculating rolling 52 weeks