Forum Discussion
What's wrong with my SAMEPERIODLASTYEAR statement?
I'm working through the edx online course, and am trying to generate a simple table showing yearly total revenue, plus a column showing the previous year's revenue. What I'm getting is a duplicate o...
The rows on your table. Where are those years coming from? Make sure they are now coming from the new date table.
If that still doesnt work, please upload a sample file.
be sure your date table is set as such:
Nick_M,
I now have a defined date table. I refreshed my view. I even exited Power BI and restarted it, but my numbers have not changed.
Mike
The rows on your table. Where are those years coming from? Make sure they are now coming from the new date table.
If that still doesnt work, please upload a sample file.
Nick,
That did the trick! I'm pretty new at this, and I guess I didn't realize the importance of having a separate date table.
Thank you for your help and patience!
Mike