Forum Discussion
NewbieJono
5 years agoPost Partisan
Week by week
i have a list count paper applications and a list of online application every day. how would i calcualte percentrage of online / paper split for the past weeks. e.g i want the total count of...
amitchandak
5 years agoSuper User
NewbieJono , You need to create date table with week information and then use week rank for this week vs last week.
Please refer y blogs for that
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