Different time aggregations for different measure within a table

[sashasneg3]

Hello,

It seems like I've hit a wall in searching for a solution to create the following table: 

                            Current Month  | LY same month |   YTD   |  YTD / LYTD  % change  |

Sum (sales)

Count (clients)

measure 3

measure 4

...5

...6

...7

 I did achieve the result visually but am very uncomfortable with how I did it.

Challenges: 

1. For 2 columns with months I created a Table with measures in rows and I am using my Date, then I have to filter on 2 months of interest. Ideally I would want the most recent month to show, as well as the same ``most recent month`` from last year - automatically, data is refreshed monthly

2. For YTD column I had to create a new table and place it next to the first table, because I can`t find a way to have 2 months AND YTD as table columns at the same time. Ideally - it should be just a column within Table 1, not a separate column

3. Finally, as I did it - the last column are in fact KPI cards mimicking table cells as each of them is a measure itself. ( I am using time intelligence to create YTD/LYTD % change, for each of the measures in Column 1, for example: Appr Avg YoY = [Appr Avg YTD] / calculate([Appr Avg YTD], dateadd(Table[Date], -1, YEAR)) -1). Sorry I can't share the data it is sensitive. Ideally, this should be a table, not 10 little KPI cards.

So the big question is: can we show 2 separate months, YTD and YOY for MEASURES as rows? 

Are there any other workarounds or more elegant ideas you might suggest? Would appreciate any comments.

Thank you in advance,

Aleksandra

[Greg_Deckler]

Having trouble following this, please refere to:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490