CALCULATE LAST WEEK

[driank]

HI,  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))

Error: A "MAX" function has been used in a True /False expession than is unsed as a table filter expression ..

Thanks

[amitchandak]

@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

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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8