Forum Discussion
Solved
Sameperiodlastyear function don't work
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: ...
Generally, for the time intelligence stuff to work you need a separate Calendar table that is related to your fact table.
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
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
thanks ! good job!