Forum Discussion
spencer_g
Helper I
Helper IPREVIOUSMONTH time intelligence
Hello Everyone, I am working with data that shows the number of visitors to a website, and I would like to show the previous month's total visitors and then ultimately the same month last year. ...
Hi spencer_g,
In your scenario, you need to have a calendar table, then create relationship using date columns between your current table and the calendar table, which is shown in the following similar screenshot.
This way, your measure should return right values. For more details, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang