Forum Discussion
switchback5
6 years agoFrequent Visitor
How to filter DirectQuery for Same Day Last Year
I am using DirectQuery to connect to my Snowflake DWH. I am trying to create a dashboard that has two very similar cards - both contain the sum of total revenue, one for yesterday's date and one for...
switchback5
6 years agoFrequent Visitor
Tried this, getting a "Couldnt load the data for this visual" error.
"OLE DB or ODBC Error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.."
Greg_Deckler
Community Champion
6 years agoswitchback5 Which one? Both? Last year is not always -364 days (leap years and such)