My question for you all is around dates. Let's say I have 5 measures (sales, average order size, frequency, active customers, order count) that I want to include in a table. I want the measures going horizontally across the top of the table. I then want to compare these measures YOY, so I want 2019 YTD compared to 2018 YTD. I want actual numbers and variances. I see there is a calculation for same period last year, however, is this truly the best way to get what I want? Do I really need to create a separate calculated measure for every metric twice? Once for 2018 YTD and once for the variances? Tableau has the ability to do this all through calculated tables without ANY manual measure calculations. Is there no way to control this with date filters alone, so I can have a singular table? I feel like I have to have 3 separte tables for this year, prior year, and variances and hide column headers to get the measures all aligned. Additionally, when I change my date selection to 2018, I want the table to reflect full year 2018 compared to full year 2017.
Thanks in advance for the help!! I am new to Power BI. Making the switch from Tableau.
