I Have Invoice date column in my table, i want to export data of last 10 weeks, what are ways to do it in timextender
Solved
filter on date column while exporting the data
Best answer by Thomas Lind
Hi Karankadam
Make a custom view where you add a rule that only gives back the last 10 weeks. Add this view as a table in your semantic model.
+5Hi
Just to confirm - you would like to bring in the last 10 weeks from a specific table in a data source into your ODX instance?
If you are looking to implement a static date filter can use row filtering (i.e. InvoiceDate > 2023-11-10)
If you are looking to implement a dynamic date filter you can use a Query Table, see example below
+5Hi Karankadam
Make a custom view where you add a rule that only gives back the last 10 weeks. Add this view as a table in your semantic model.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
