Forum Discussion
Last 4 quartes trend
Hi All,
I would like get X Axis as last four quarters based on the today's quarter and year (current quarter and 3 quarters before) .
Example 1): when today is October 22, 2019 i want to show Q4, Q3,Q2,Q1 in 2019
Example 2): When today is April 2020 i want to show Q2, Q1 in 2020 and Q4, Q3 in 2019.
Thanks!
Regards,
Oleh
Hi Anonymous
You can create a relative date dimension like in the article below.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
3 Replies
Hi Anonymous
You can create a relative date dimension like in the article below.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.Thanks Mariusz !
It works)
I have one small question - is this Date Dimension Table dynamic and based on today's date?For example:
Today is Decуmber 31, 2019 and rYearQuarter = 0.
Tomorrow will be January 1st, 2020 and what rYearQuarter for that date will be when i'll open my report: 0 or 1?
1) 0 (because table is dynamic and changes everyday)?
2) 1 (because table is created once and it is static)?
Many thanks for your help!
Regards,
Oleh
Hi Anonymous
The table is dynamic and it will change every time you refresh the dataset, so yes in Jan 2020 the rYearQuarter will be 0.
Best Regards,
Mariusz
Please feel free to connect with me.