Hey guys, I just started using Power BI and had a couple quick questions. I'm trying to create a table to show data per quarter. So far I have it setup so that it outputs the data correctly per quarter, however I want to try to fix the following-
- The quarters are in the wrong order. For example I am sorting by Years, so the years in the table go from top to bottom-2017,2016,2015, etc. whereas the quarters go 1,2,3,4. I would like the quarters to be in the order 4,3,2,1, so that all of the data is in order
- I would only like it to show data for the past 12 periods. Currently it is showing all the data from the top most value onwards. I would like to (ideally) be able to refresh the data in 2 years, and have it update to show the last 12 quarters from that point.
- I have dates in two different Tables. I would like them to be tied together, so that I can use one date to sort by. For example
- Table 1 contains "sales by date for store 1" and table 2 contains "sales by date for store 2". I would like to tie these two together, so that I can have a single column "sales by date for all stores" to compare data on.
Thanks a ton! I know this may be a bit much, but I'm quite a beginner, and any help would be appreciated. Thanks again!
