cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sashasneg3
Frequent Visitor

Different time aggregations for different measure within a table

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

1 REPLY 1
Greg_Deckler
Super User
Super User

Having trouble following this, please refere to:

 

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

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors