Same Period Last Year - Full Year & PiT in same table

Try

Sales Same Period Last Year =
CALCULATE (
    [Amount Measure],
    CALCULATETABLE (
        DATEADD ( DATESYTD ( 'Date'[Date] ), -1, YEAR ),
        TREATAS ( { TODAY () }, 'Date'[Date] )
    )
)

Hi johnt75 

Thanks for the suggestion and gave that a go, but definitely some unexpected results in there...

DTS SAles PY (FullYear) is essentially the SamePeriodLast Year Measure without the calculated column visual level filter applied and I know those figures are good. TEST column in your suggested Measure - you will see the second line down that it calculates Sales approx 18k above the whole of the previous year.

If you have values from your date table in the visual then you don't need the bit about today, you could just use

Sales Same Period Last Year =
CALCULATE ( [Amount Measure], DATEADD ( DATESYTD ( 'Date'[Date] ), -1, YEAR ) )

Hello,

First of all you should create a Date Dimension and link that to your table that has the Sales. So based on the PoC, that i have done for your question i have created two tables:

1. The Date Dimension

2. The Sales Table

In the data model view i have conneted the date dimension to the Sales table. (key is Date)

And in the report view i have added a Slicer for date and a table having 3 columns

1. Sum of Sales (the sum of sales for the date range selected)

2. SalesSamePeriodLY

SalesSamePeriodLY = 
    CALCULATE(
        SUM(sales_powerbi_answers[Sales]),
        SAMEPERIODLASTYEAR('Date'[Date])
    )

which according to the date data and if the dates available SAMEPERIODLASTYEAR(), calculates the exactly same period but for the previous year, based on the selected data.

3. SalesFullLastYear

SalesFullLastYear = 

var _Current_Year = CALCULATE(MAX('Date'[Date]),ALLSELECTED())
var _Previous_Year = YEAR(_Current_Year) - 1

RETURN

CALCULATE(
    SUM(sales_powerbi_answers[Sales]),
    YEAR('Date'[Date]) = _Previous_Year
)

which calculates the max available date and based on that calculates the sum of sales for the previous year.

The result (as you can see the Full Last Year remains constant and the Same Period Last Year changes based on the range selected)

i hope this helps.