Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a fact table with a date column and a calculated column which shows Quarter-Year.
I've created a Matrix which shows a simple SUM of the values column by the quarters. What I need to do is always show the Last 4 quarters only, excluding the Current Quarter.
I'm sure there is a good trick, but I've not been able to catch it yet, please help!!
PS the reason you don't see Current Quarter data in the image is because we don't have that data yet, we usually get it be the close of the 2nd month of the quarter.
Thanks in advance!
Solved! Go to Solution.
Hi @DotU ,
I can give you a solution!
First you will need to create a calculated column that it's going to be a related quarter index:
And on the visual that you want to filter you have to add this new column as a filter and select only the values (1, 2, 3, 4) to have dynamically the last 4 quarters excluding the actual one.
like this:
i hope i solved your problem! 🙂
Hi @DotU ,
I can give you a solution!
First you will need to create a calculated column that it's going to be a related quarter index:
And on the visual that you want to filter you have to add this new column as a filter and select only the values (1, 2, 3, 4) to have dynamically the last 4 quarters excluding the actual one.
like this:
i hope i solved your problem! 🙂
omg, the math behind this is sooo pretty! and yes it works.
If i show you guys what all i was starting to do, you will have a good laugh, lol
Thank God I stopped and asked!!
Thank you sooo much for your help!!!!!
No problem, I'm glad i could help!
Sometimes the easiest solution is the best!
,
It is possible but very long to explain.
Look at this video and everything will be clear.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
59 | |
45 | |
42 |