Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Measure of YoY with weeks

Could you help me creating a measure that calculates me the info of YoY based on weeks. I would need a new column in front of final revenue that indicates the revenue of past fiscal year  on the same quarter and week


Super User
Super User



We must have a Calendar Table running from the first date appearing in the Date column of your Table to the last date in that column.  In the Calendar Table, there should also be a Week column.  Can you do that?  Also, what is your financial year (from which month to which month)?

Ashish Mathur

Hi, Our Fiscal Calendar starts 1st November and ends 31 of October. Also our weeks are Sunday from Saturday and i need to split them in weeks 



In the Calendar Table, can you create a weeek number column?  I will need that.

Ashish Mathur

This is the new file with date table"M_Dates" and with "Week"Column. Thanks for your help





My formula in this file gives no result because the weeks/quarters and FY are not properly aligned between the M_dates table and the Date table.  Once you corect for that, my formula will work well.

Ashish Mathur

What do you mean when you said they no are aligned. This calendar Date is a customized table with our weeks, months and FY



By that i mean that the week number and/or FY and/or quarter appearing against a particular date in the Data Table is not the same as the one on the Calendar Table.

Ashish Mathur

Actually that is my problem because we have customized dates in our FY and that way is how they are set



Actually we do not need to have FY, quarters and weeks at all in yout base data sheet.  These columns should only be in your Calendar Table.  The Actual date column in your base data sheet should bear a relationship to the Date column in the Calendar Table.  So it is important that the FY, quarters and weeks in the Calendar Table should be correct.

Ashish Mathur
Resident Rockstar
Resident Rockstar

Hi @espinale ,


Please try the measure below.


PY = 
    SUM ( 'table'[Revenue] ),
    FILTER (
        ALLSELECTED ( 'table' ),
            = MAX ( 'table'[Year] ) - 1
            && 'table'[WeekNum] = MAX ( 'table'[WeekNum] )
            && 'table'[Qtr] = MAX ( 'table'[Qtr] )

Here is the output.



More details, please refer to my test pbix which has been attached.


If you still need help, please share your data sample and your desired output so that we could help further on it.


Best  Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This is the Link  PBX

I tried that solution but It's not working. I can attach the PBX file but i dont see the option, if you teach me i can do it

Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors