Forum Discussion

nhaghani's avatar
nhaghani
Icon for Helper I rankHelper I
4 years ago
Solved

SAMEPERIODLASTYEAR is blank

Hello,   I am new to power BI   I am trying to get LY YTD for my sales $. I am not getting any error, but just blank data.   I did add below but again it just returns blank with no error. Pleas...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi nhaghani ,

    According to your description, I create a sample.

    I think you should put a date column in the visual, the SAMEPERIODLASTYEAR function should be based on an exact date.

    LY-YTD Dotcom = CALCULATE(SUM('Ulta Dotcom'[Sales]),SAMEPERIODLASTYEAR('Ulta Dotcom'[Ending-Date]))

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi nhaghani ,

    I'm clear, you can modify the formula like this:

    LY-YTD Dotcom =
IF (
    MAX ( 'Ulta Dotcom'[Ending-Date] )
        > DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) ),
    BLANK (),
    CALCULATE (
        SUM ( 'Ulta Dotcom'[Sales] ),
        SAMEPERIODLASTYEAR ( 'Ulta Dotcom'[Ending-Date] )
    )
)

    Best Regards,
    Community Support Team _ kalyj

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Yes, i am already using the same formula....
AP Header Total Sales Previous Year = CALCULATE(SUM('AP Ops Header Level Report- PS'[sum(Amount Invoiced)]),SAMEPERIODLASTYEAR('AP Ops Header Level Report- PS'[[INV-P&I]]Accounting Date (Date)]))
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Create a Calendar Table with a relationship from the Accounting Date column of your Table to the Date column of the Calendar Table.  In the Calendar Table, write calculated column formulas to extract Year, Month Name and Month number.  Sort the Month name column by the Month number.  To your visual, drag Year and Month name from the Calendar Table.  Write these measures

Total = SUM('AP Ops Header Level Report- PS'[sum(Amount Invoiced)])

Total in same period last year = calculate([Total],sameperiodlastyear(calendar[date]))

Hope this helps.