March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
Imagine I have a table like this:
Company Name | Invoice Date | Price |
A | 01-01-2019 | 100 |
A | 01-02-2019 | 130 |
A | 01-03-2019 | 140 |
A | 01-04-2019 | 120 |
A | 01-05-2019 | 130 |
A | 01-06-2019 | 110 |
A | 01-07-2019 | 100 |
A | 01-08-2019 | 140 |
A | 01-09-2019 | 520 |
A | 01-10-2019 | 200 |
A | 01-11-2019 | 120 |
A | 01-12-2019 | 345 |
A | 01-01-2020 | 245 |
A | 01-02-2020 | 200 |
Then I put that in a matrix like this:
Which is fine. However, I would like to - AFTER the date columns, to be able to put some measures. I would like to put a measure for: "FY Sales LY" , "Sales LTM", "Diff LY vs LTM". But I can't seem to make that work. Then it puts it under each month if I put it as values. Is it possible in any way? My output I want is something like this:
Thanks!
Solved! Go to Solution.
OK, I updated it so that it handles all months, I was just getting it to work. Just requires copying and pasting a bunch of code and tweaking them for each month. Attached.
Attached a possible path to a solution.
Thanks! I just tried it and seems to work alright - however it is made just for january right? How do I make it, if it has to take "any month" last year, and the YTD Months this year?
So lets say - from Jan-19 to whatever current month always?
OK, I updated it so that it handles all months, I was just getting it to work. Just requires copying and pasting a bunch of code and tweaking them for each month. Attached.
Thanks a million!
the last thing is that it sorts the months A-Z, how can I alter that? I have tried without luck
Glad it works!! Honestly, I thought that it came out way too convoluted to be of use but it was the only way I could think of to do what you wanted without trying to smash two visuals together.
I added a sorting column to the data and did a "Sort By" column for Value 2 column. Updated PBIX.
This is the most complicated measure I have ever had to be honest 😉
But it works! Only limitation is that it is not possible to do "sorting" by clicking on the columns. But that is just how it is!
Thanks a million @Greg
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
143 | |
97 | |
79 | |
68 |