Forum Discussion
Week on Week Percentage Change in chart
Hi Anonymous
If your [Total Visit] should be the number of visits in a week, and [Customer Paid per Visit] should be the number of paid visits in the same week, you could try below measures. Let me know if I misunderstood it.
Total Visit = COUNT('Table'[Index])Paid Visit = COUNTROWS(FILTER('Table','Table'[Customer Paid]="Yes"))Week Change = DIVIDE([Paid Visit],[Total Visit])This Week % change = var _thisWeek = WEEKNUM(MAX('Table'[Date of Visit]),21) return CALCULATE([Week Change],'Date'[Week of Year]=_thisWeek)Last Week % change = var _lastWeek = WEEKNUM(MAX('Table'[Date of Visit])-7,21) return CALCULATE([Week Change],'Date'[Week of Year]=_lastWeek)Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello there Anonymous ! It looks like the filed you are using in the X axis has no relation with the calculations you have performed? Do you have a calendar table/date dimension? Are you using it in the time intelligence ou time related analysis?
You can dive a little deeper in these concepts in the following links:
Create a Date Dimension in Power BI in 4 Steps - Step 1: Calendar Columns - RADACAD
Using a Date Dimension Table in Power BI (sqlshack.com)
Time Intelligence in Power BI Desktop - SQLBI
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Yes. I have a date dimension with list of dates
The week of year is a column created using
Week of Year = WEEKNUM('Date'[Date],21)