Time functions: difference in Powerpivot Excel vs SSAS?


  • Hello,

    I am trying to create a previous made powerpivot dashboard into a tabular model. I am running into a few errors concerning date intelligence functions.

    The expressions "DATESYTD" and "SAMEPERIODLASTYEAR" seem not to work in my tabular model. I did not change anything in the relations between my fact table and my dim tables!

    These expressions worked flawless in my powerpivot model.

    For example:

    YTD Tons Year:=calculate(sum(FactSales[Ton]),datesytd(Calendar[FullDate]))

    I want to show the YTD tons per month. In powerpivot this worked perfect, in my tabular model, it just gives me the MTD values.

    Can anyone assist me in this?

    Thank you very much for the help provided.

    Kind regards,


    Monday, October 28, 2013 9:06 AM