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
Best answer by Thomas Lind
View original
Userlevel 6
+5
Hi
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
any suggestion
Userlevel 6
+5
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
