Skip to main content

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

Hi @Karankadam 

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

 

@Christian Hauggaard  i have table in my moderndata warehouse i want to export it to Semantic Model (or From Semantic Model to CSV file), and it should export only last 10 weeks data

any suggestion @timextender @Christian Hauggaard 

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


Terms and ConditionsCookie settings