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.

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

Why are the tables not related.  There should definitely be a relationship (Many to One and Single) between the Date column in your Data Table to the Date column in the Calendar Table.  In the Calendar Table, create caclualted columns for Year, Month name, Month number and Quarter.  To your visuals, drag the Date dimenstions from the calendar Table.

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.