Forum Discussion

rohit403's avatar
rohit403
Helper I
7 years ago

Calculating YOY% change

Hi All,   I need your advise and help in calculating YOY (year on year) percentage change. The data as well as the result required is in the below format. I have a date table too, whose screenshot ...
Need Help
moumipanja's avatar
moumipanja
Microsoft Employee
7 years ago

How's your first table connected with your Date table? I can't see a common column. Once you define the connection, it would be easy to create the DAX for the YoY change

  • rohit403's avatar
    rohit403
    Helper I
    7 years ago

    Hi moumipanja,

     

    Thanks for your response.

     

    Apart from the Date table, there is another table Time in Financial (screenshot 1 below) which have start dates and end dates (in DD-MM-YYYY) format corresonding to the quarters. This table is connected to the table (screenshot 2 below) with values and where I need to perform the calculations. The date table screenshot shared earlier have the end and start dates. Whereas the data table have the quarters (which is also in Time in Financial.

     

     

    Screenshot 1Screenshot 2

    Look forward to your help and response.

     

    Thanks,

    Rohit