Forum Discussion

koorosh's avatar
koorosh
Post Partisan
3 years ago

Same Period Last Year

Hi, Why sameperiodlastyear did not result in one year back from the date column selected?    
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

SELECTCOLUMNS('Table',"Date",SAMEPERIODLASTYEAR('Table'[Date]))
will give empty at the beginning , go down and you see dates

  • koorosh's avatar
    koorosh
    Post Partisan
    3 years ago

    Thanks. Why there are no empty rows or 2013 rows in the sameperiodlastyear table?
    And why there is no 2013 rows in selectcolumn table and it shows empty rows ?