Forum Discussion
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...
amitchandak
Super User
Super Userswitchback5 , same day last year is 364 days behind with a date table
Same day Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,Day))
if need you can have date table in power. Check if it supported with snowflake
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
switchback5 Which one? Both? Last year is not always -364 days (leap years and such)
