Sameperiodlastyear function don't work

[michelangelo_fi]

Hi,

i have a simple table called TMP with 3 columns {DATE, PRODUCT, QUANTITY} and i try to obtain the total quantity of the previous year.

So i use SAMEPERIODLASTYEAR() function in this manner: 

TOTAL QUANTITY LY = CALCULATE([TOTAL QUANTITY];SAMEPERIODLASTYEAR(TMP[DATE]) )

The measure TOTAL QUANTITY is : 

TOTAL QUANTITY = sum(TMP[QUANTITY])

But when i check the results i get this: 

As you can see the column TOTAL QUANTITY LY is blank .....what's wrong?

Thank you for yours reply!!!

[Greg_Deckler · Accepted solution]

Generally, for the time intelligence stuff to work you need a separate Calendar table that is related to your fact table.

[alexei7 · Accepted solution]

Hi,

I think you need to have a separate "date" table for this to work, and join it in the model view to your TMP table.

Then in your Power BI visual, you bring in year/anno from the date table, and the Total Quantity and Total Quantity LY fields.

I did this and it worked for me.

Alexei

[michelangelo_fi]

thanks ! good job!

[Greg_Deckler · Accepted solution]

Generally, for the time intelligence stuff to work you need a separate Calendar table that is related to your fact table.

[michelangelo_fi]

thanks a lot Greg! now it works!