204
Hi Team,
Trying to get the last 2 years of data from today's date using the run a query against a dataset connector.
Unsure if my code is incorrect but it fails with Expression.Error: We couldn't fold the expression to the data source. Please try a simpler expression
Any help is greatly appreciated.
Share
ReportEVALUATE
FILTER (
'vals',
YEAR ( DATEVALUE ( [DATEEND] ) )
>= YEAR ( TODAY () ) - 2
)
Hi @christian12
Since you are using DirectQuery there are definitely some limitations. I dont know they all by heart.
Can you try intentionally hardcoding it to just
DATEVALUE([DATEEND]) > AnyDateFrom2YearsAgo
Also I do know some of the limitations are on Date columns. So just trying to remove anything that might impact folding. as it could be a simple as you just comparing Year
Also, have you thought about doing a column that makes DATEEND an actual date, and leaving the string one in so you dont need to convert it?
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
All responses (
Answers (
