NAME:
Last-Year-to-date performance measure
DESCRIPTION:
Calculate the sum of some column containing numerical values from 1/1 last year up until today's date last year.
PARAMETERS:
Name: Base value
Tooltip: The value you want to measure last-year-to-date performance on
Type: Numerical field / measure
Name: Dates
Tooltip: The dates you want to use for the year-to-date period. The last-year-to-date measure assumes that you have atleast 2 years within your data set.
Type: Date field
DAX:
First you create the year-to-date measure (referring to my post about year-to-date😞
SUM {Base value} YTD =
Calculate(
SUM({Base value}),
DATESYTD({Dates})
)
Then you create the last-year-yo-date measure based on the year-to-date measure:
SUM {Base value} LYTD =
Calculate(
[SUM {Base value} YTD],
DATEADD({Dates};-1;YEAR)
)
If you take a look at the .pbix, you'll find syntax for creating a time dimension and making the monthname + year column.
Don't hesitate to ask about the measure. I'll gladly elaborate on anything regarding it.
