Forum Discussion

koorosh's avatar
koorosh
Icon for Post Partisan rankPost 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
Icon for Super User rankSuper 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
    Icon for Post Partisan rankPost 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 ?