Advanced date filter for terms like "Today" and "Yesterday"

[Phil_Seamark]

When I use the Q&A feature, I can use terms like Today, Yesterday, Last week etc.  This is really cool.  I also note that the Q&A adds these terms to the filter box.

What I'd like to be able to do is to create those terms when doing normal report page editing.  Any thoughts on when this might be available?

[v-caliao-msft]

@Phil_Seamark

Based on your description, you need a filter like Today and Yesterday in your report, right?

If that is the case, please refer to the steps below to achieve it.

1. Create a new table by using Enter Data.
   
2. Create a calculated column in original table
   Difference = 1*(QA[Date]-today())
   
3. Create a realationship by using Difference column in two tables.
   
4. Then you can use the Item column into your slicer.
   

Reference
http://www.powerpivotpro.com/2013/03/guest-post-always-show-yesterday-today-or-tomorrows-data/

Regards,

Charlie Liao

[Phil_Seamark]

Hi @v-caliao-msft,

Thanks for taking the time to respond and I do that now for models I build in Power BI Desktop and upload to the Service.

However the model I am interested in using this for is a dataset created using the API.  You can't create relationships or calculated measures yet (I understand this is in Preview) via the API.