LY YTD specific

---

Anonymous wrote:

Hi 

 

I am trying to get number of meetings YTD and LY YTD for a metrix where I have countries on the row. 

 

Total meetings = SUM('meetings'[meetings count])

 Total meetings YTD = CALCULATE([Total meetings], DATESBETWEEN('meetings'[Created Date],"1/1/2017",TODAY())

 - i am using this because there are dates in the future (planed meetings)

Total meetings LY YTD = ???

 

I was thinking to use the DATEADD(DATESBETWEEN('meetings'[Created Date],"1/1/2017",TODAY()),-1,Year) but obviously that doesnt work...

or even mor complicated idea :) =  DATESBETWEEN('meetings'[Created Date],"1/1/2017",DATEADD(TODAY()),-1,Year) which is even bigger nonsense but i am running out of ideas here.. as I tried same period last year 

 

 

 anyone with suggestion?

 

Thank you 

 

 

---

Anonymous

Roughly, you could try

Total meetings LY YTD =
CALCULATE (
    [Total meetings],
    DATESBETWEEN (
        'meetings'[Created Date],
        DATE ( YEAR ( TODAY () ) - 1, 1, 1 ),
        DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) )
    )
)