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.
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.
I had tochange in tabular model my "DIM Calendar" to date table. Now every expression works fine.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?