YTD measure for different months

[FR14]

Hi Everyone 🙂

I am looking for a way to show YTD,MTD, for different months this yea and last year.

These are my YTD and MTD formulas could you please let me know if they are correct? how can i modify them to show for previous year?

CY Bookings Annualized = Calculate(SUM(OrderLine[Booking USD]), YEAR('OrderLine'[Open_Date]) = YEAR(TODAY()), MONTH('OrderLine'[Open_Date]) <= MONTH(TODAY()))

CY MTD Bookings Annualized USD = Calculate(SUM(OrderLine[Booking USD]), YEAR(OrderLine[Open_Date]) = YEAR(TODAY()), MONTH(OrderLine[Open_Date]) = MONTH(TODAY()))

Thank you very much!

[FR14]

Thank you very much! great help! how about MTD and QTD formula?

[nirali_arora · Accepted solution]

Modification for previous year

CY Bookings Annualized =

CALCULATE (

SUM ( OrderLine[Booking USD] ),

YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ),

MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()

)

)

PY Bookings Annualized =

CALCULATE (

SUM ( OrderLine[Booking USD] ),

YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ) - 1, -- Adjust for Previous Year

MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()

)

)