Forum Discussion
Helper IVCreate Previous Week Filter?
If you need to have as a slicer different custom time periods you need to use "disconnected slicers" and measures for all time periods. Search in powerpivotpro.com as there are many articles about it like:
Helper IVThank you very much for your response PowerBIGuy. Unfortunately, I do not think this solution is working for my particular case (or I am mistakenly doing something)
Below is my usage of your suggestion.
I'm trying to create a column that lists each date as within the "Previous Week", if not, "Null"
Thank you again for your suggestions!
Responsive Resident
Maybe it's your data model. my example uses a date dim. Sorry it didn't work out.
- cwayne758
I think it very well could be.
I retried, this time using my DateStream date table from Azure Marketplace
Error message: In DATEDIFF Function, Start Date cannot be greater than End Date.
When I switch my Start Date to reference dates in my FactTable, and End Date to reference dates in my DateStream table, my only result is 2.
Again, thank you for your replies!
- PowerBIGuy
No problem happy to help. I also got the same error. I Just filtered by date dim to exclude future dates to aviod the error.