Forum Discussion
SevsBo
Responsive Resident
1 year agoTime 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
Responsive Resident
1 year agoI get blank results when using the above approaches. Just thinking it's because of DirectQuery, would that make sense?
Joe_Barry
Solution Sage
1 year agoI 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