Forum Discussion
How to fix Date X Axis?
Hello! To give context I am trying to count the number of transactions done in established periods such as (Actual month or Past month). For this, I used calculated measures: Actual Month = VAR ...
Simplify your measure to use EDATE(-1) for the previous month and EDATE(-12) for the same month last year. Note that the majority of "Previous Month" combinations will have different numbers of days, making the comparison less useful. And even with the same month last year the weekdays will differ which may again skew the comparison.
Thanks for the rec! I was trying to graph it that way since it was a request from my supervisor because they usually like to see the number of transactions per day for those months (I only could achieve that by using calculated columns, but they aren't a dynamic way to observe the data since it cannot be filtered), but it seems that it cannot be graphed?