Wednesday, August 15, 2012 6:22 PM
What is the DAX Function to report on just the previous week. Mon-Friday, not 7 days prior to today.
I see there are a lot of intelligent date functions for previous month, quarter, year etc, but nothing for previous week.
If there is a way to do this, please let me know.
Wednesday, August 15, 2012 7:41 PM
I figured out how to do this, but decided to reply to myself incase anyone else has the same problem and does a websearch for the solution. When importing your data in powerpivot, choose the "select from a list of tables and views to choose the data to import" Select the table and then click on the button "preview and filter". Locate your date field and click on the down arror on the column header. Select Date Filter and then select Previous week. Continue to filter for other data as you like and then finish.
Note: With PowerPivot, it helps to 'read the manual' :)