sameperiodlast year not working RRS feed

  • Question

  • I have the measure:

    prior = CALCULATE(sum('fact'[01valuefield]),SAMEPERIODLASTYEAR('Date'[Solar_Date]),

    ALLEXCEPT('Date','Date'[Solar_Date]) )

    it seemed to work last year through December. now in January I get all the data from 2019

    what am I doing wrong?



    Monday, January 6, 2020 8:34 AM


  • I had a table with contiguous dates, but it was not a date table. I created a date table and linked it in a 1:1 relationship to my table of dates and things are working better


    • Marked as answer by berli Thursday, January 9, 2020 3:43 PM
    Thursday, January 9, 2020 3:43 PM