Results 1 to 2 of 2

Thread: Custom Quarter over Quarter

  1. #1
    Seeker Sagittariu5's Avatar
    Join Date
    Sep 2020
    Posts
    11
    Articles
    0
    Excel Version
    2016

    Custom Quarter over Quarter



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,


    I’m trying to create a Quarter over Quarter measure, but been unsuccessful in my attempts.
    Please note the Period table doesn't have any dates, since the Calendar is a combination of a Ravinia and Julia Calendar.

    PrevQtr = CALCULATE(SUM([BONUS]),FILTER(Period,Period[Quarter]<=EARLIER(Period[Quarter])))
    QoQ = =DIVIDE(SUM([BONUS]), [PrevQtr]) - 1

    Period Table
    Quarter Year
    Qtr 1 2019
    Qtr 2 2019
    Qtr 3 2019
    Qtr 4 2019
    Qtr 1 2020
    Qtr 2 2020
    Qtr 3 2020
    Qtr 4 2020
    Qtr 1 2021

    Background, the Calendar is a combination of a Ravinia and Julia Calendar starting from 12/10/2018, which has custom Month (4 Weeks), Quarters (13/14 weeks) and Year (52 Weeks) until 2020/1/1 where the Julian Calendar would be being.

  2. #2
    Seeker Sagittariu5's Avatar
    Join Date
    Sep 2020
    Posts
    11
    Articles
    0
    Excel Version
    2016
    Found a solution, via this link https://stackoverflow.com/questions/...es-in-power-bi

    Create a grouped index column (calculated column), which creates a groups for each Year - quarter and then sorted them alphabetically adding an index number.
    Index =RANKX(SUMMARIZE(Period,Period[Qtr Year]),Period[Qtr Year],,ASC)
    So then correct measure PrevQtr = CALCULATE(SUM([BONUS]),FILTER(ALLSELECTED(Period),Period[Index]=MAX(Period[Index])-1))
    and QoQ =DIVIDE(SUM([BONUS]), [PrevQtr])

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •