Forum Discussion
What's wrong with my SAMEPERIODLASTYEAR statement?
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
Anonymous
No problem at all. Need a separate date table to make the built in time-intelligence work correctly. Plus you never want to filter ( which is what is happening in a pivot table, slicers, etc) your main (fact) table. Always want smaller tables, like the date table, to be filtered and then "Send" those filters to your bigger fact tables. But that's a grossly simplified explanation. Just takes some time to get used to it. Good luck