Forum Discussion
BItoken
Helper III
Helper IIIUrgent - Trailing 4 quarters Sum
Hi Everyone, I have last 12 Qtrs in my Power BI report and i have to add a column to show Trailing 4 quarters sum running until the current qtr For example i need Sum of FY19-Q1,Q2,Q3,Q4 at FY-...
Hi,
You may download my PBI file from here. Let me know if you are OK with this. If you want the first 3 rows to definitely show a blank, then post back and i will modify my formula.
Hope this helps.
BItokenHelper III
Helper IIIYes first 2 columns are coming from my Data tables.
Apr to June is Q1
So ex: Apr 1 2020 to June 30 2020 is FY 21 Q1
| FQ | Sales | Trailing 4 Qtrs |
| FY19-Q1 | 40 | |
| FY19-Q2 | 50 | |
| FY19-Q3 | 70 | |
| FY19-Q4 | 60 | 220 |
| FY20-Q1 | 40 | 220 |
| FY20-Q2 | 80 | 250 |
| FY20-Q3 | 100 | 280 |
| FY20-Q4 | 200 | 420 |
| FY21-Q1 | ||
| FY21-Q2 | ||
| FY21-Q3 | ||
| FY21-Q4 |
Ashish_Mathur
Super User
Super UserHi,
You may download my PBI file from here. Let me know if you are OK with this. If you want the first 3 rows to definitely show a blank, then post back and i will modify my formula.
Hope this helps.