Forum Discussion
SevsBo
1 year agoResponsive Resident
Time Intelligence Functions not working - what am I doing wrong?
I have raised several questions over Time Intelligence functions which made me realise I'm probably doing something fundamentally wrong with then. At the moment I have a SalesTable that is a Dire...
- 1 year ago
I have check with direct query and I get the same result. I wasn't aware of this restriction myself as I usually load my tables. Here is the documentation https://learn.microsoft.com/en-us/dax/?view=sql-server-2017
SevsBo
1 year agoResponsive Resident
I get blank results when using the above approaches. Just thinking it's because of DirectQuery, would that make sense?
Joe_Barry
1 year agoSolution Sage
I have check with direct query and I get the same result. I wasn't aware of this restriction myself as I usually load my tables. Here is the documentation https://learn.microsoft.com/en-us/dax/?view=sql-server-2017