Forum Discussion
driank
5 years agoRegular Visitor
CALCULATE LAST WEEK
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) = WEE...
amitchandak
Super User
5 years agodriank , 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-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8