- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Having trouble following this, please refere to:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Follow on LinkedIn
@ 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!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-19-2024 05:38 AM | |||
01-27-2024 02:20 AM | |||
03-18-2024 11:08 AM | |||
06-20-2023 01:28 PM | |||
04-13-2024 01:19 PM |
User | Count |
---|---|
113 | |
77 | |
55 | |
54 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |