Forum Discussion

Switto's avatar
Switto
Icon for Helper IV rankHelper IV
4 years ago
Solved

Current year current quarter vs Previous year same quarter

Hello Everyone,

 

We have a measure created for the current year current quarter:

var _1 =
MAXX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]= TODAY()),'Calendar'[FY QTR])
return
CALCULATE(AVERAGE(WorkTransferRequest[Current Penetration]),FILTER('Calendar','Calendar'[FY QTR]= _1))
 

I am also searching for the previous year same quarter measure as well so we can compare the results.

Is it possible to achieve?

Thanks

Switto

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Switto ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    currentquarter =
var _today=TODAY()
var _todayyear=YEAR(TODAY())
var _todaymonth=MONTH(TODAY())
var _todayquarter=QUARTER(TODAY())
var _currentquarter=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[year]=_todayyear&&'Table'[quarter]=_todayquarter))
return
_currentquarter
    Previousyearsamequarter =
var _today=TODAY()
var _todayyear=YEAR(TODAY())
var _todaymonth=MONTH(TODAY())
var _todayquarter=QUARTER(TODAY())
var _Previousyearsamequarter=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[year]=_todayyear-1&&'Table'[quarter]=_todayquarter))
return
_Previousyearsamequarter
    Flag =
IF(
   MAX('Table'[year])=YEAR(TODAY())&&MAX('Table'[quarter])=QUARTER(TODAY()),1,0)

    3. Place [Flag] in Filters, set is=1, apply filter.

    4. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Switto ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    currentquarter =
var _today=TODAY()
var _todayyear=YEAR(TODAY())
var _todaymonth=MONTH(TODAY())
var _todayquarter=QUARTER(TODAY())
var _currentquarter=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[year]=_todayyear&&'Table'[quarter]=_todayquarter))
return
_currentquarter
    Previousyearsamequarter =
var _today=TODAY()
var _todayyear=YEAR(TODAY())
var _todaymonth=MONTH(TODAY())
var _todayquarter=QUARTER(TODAY())
var _Previousyearsamequarter=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[year]=_todayyear-1&&'Table'[quarter]=_todayquarter))
return
_Previousyearsamequarter
    Flag =
IF(
   MAX('Table'[year])=YEAR(TODAY())&&MAX('Table'[quarter])=QUARTER(TODAY()),1,0)

    3. Place [Flag] in Filters, set is=1, apply filter.

    4. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Switto , In case you have date and Qtr start from Jan, Apr, Jul, Oct(Order is not important)

     

    QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

    Last year same QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,Year)))
    Last year same QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(ENDOFQUARTER(dateadd('Date'[Date],-1,Year))))

     

     

    With new columns in date table

    Qtr Start Date = DATEADD(STARTOFYEAR('Date'[Date],"4/30"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)
    Qtr Rank = RANKX(all('Date'),'Date'[Qtr Start date],,ASC,Dense)


    This Qtr = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])))
    Last Year same Qtr = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-4))

     

    Power BI — Qtr on Qtr with or Without Time Intelligence
    https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
    https://www.youtube.com/watch?v=8-TlVx7P0A0