Forum Discussion

cheid1977's avatar
cheid1977
Icon for Advocate I rankAdvocate I
9 years ago
Solved

SamePeriodLastYear

Over the last few months I have created multiple dashboards using DirectQuery. Within the dashboards I used the "SAMEPERIODLASTYEAR" function and it worked without any problems. I recently had my com...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

maybe enabling this option will resolve your issue

 

Maybe this document will also be of interest

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016

 

And also this site may be of interest, there are a lot of examples available how to rewrite TimeIntelligence functions, if these functions are not available (this site has been responsible that I write all my DAX statements without the usage of special timeintelligence functions :-))

http://www.daxpatterns.com/time-patterns/

 

Hope this helps