Forum Discussion
QoQ, YoY Calculations not Working
Hi Experts! I have a data model below. Date and Fact tables are not related. I need help in checking why the Same Qtr PY Actual column is not showing the right value. I am using this measure to g...
Sure Ashish_Mathur . Please see data attached below:
NOTE: My Fiscal Year starts on July 1st and and June 30, thus show the date table below.
Fact Table:
| Segmentation | Fiscal Year | Fiscal Quarter | Actual |
| Strategic | FY22 | FY22-Q1 | 984 |
| Strategic | FY22 | FY22-Q2 | 1119 |
| Strategic | FY23 | FY23-Q1 | 60 |
| Enterprise | FY22 | FY22-Q1 | 16605 |
| Enterprise | FY22 | FY22-Q2 | 23451 |
| Enterprise | FY23 | FY23-Q1 | 162 |
| Corporate | FY22 | FY22-Q1 | 15342 |
| Corporate | FY22 | FY22-Q2 | 18957 |
| Corporate | FY23 | FY23-Q1 | 558 |
| SMC - Scale | FY22 | FY22-Q1 | 28749 |
| SMC - Scale | FY22 | FY22-Q2 | 28128 |
| SMC - Scale | FY23 | FY23-Q1 | 258 |
Date Table:
| Date | FiscalMonth | FiscalYear | FiscalQuarter | FiscalYearQtr |
| 7/1/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/2/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/3/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/4/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/5/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/6/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/7/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/8/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/9/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/10/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/11/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/12/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/13/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/14/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/15/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/16/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/17/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/18/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/19/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/20/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/21/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/22/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/23/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/24/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/25/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/26/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/27/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/28/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/29/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/30/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
| 7/31/2021 0:00 | 1 | 2022 | Q1 | FY22-Q1 |
- Ashish_Mathur
Super User
Ashish_Mathur - you just saved me a ton of time! exactly what I'm looking for. I'll apply those steps in my actual pbi file now. Thanks a lot!
- Ashish_Mathur
You are welcome.