Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ashish_Mathur - thanks for the reply.  I only have the Fiscal Quarter(FY22-Q1), and Fiscal Year(FY22) columns in the data table right now.  So, I can use the Fiscal Quarter column to relate the tables?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Using whatever columns you have, we will first have to create a proper Date column and then build a Calendar Table from here.  Share the months which each quarter covers and also your PBI file.