KNOWLEDGE BASE

Relative Date Filter Returns Incorrect Results When Connecting to a MSAS cube


Published: 11 Mar 2019
Last Modified Date: 22 May 2019

Issue

A relative date filter set to return the last three weeks actually returns 5 or 6 days less than expected when using a Microsoft Analysis Services connection.

For example: 

  • When a relative data filter is set to return 3 weeks, the correct dates are returned in the filter but only 2 weeks are showed in the view.
  • Thehe view returns 5 or 6 days less than expected at the beginning of the period depending on the starting day of the week. When the week starts on Sunday, 6 days are missing. When the week starts on Monday, 5 days are missing.
  • The expected result is computed correctly in the filter. The data returned by the query is incomplete.

Environment

  • Tableau Desktop
  • MSAS

Cause

This issue (ID: 878289) has been fixed in a recent release of Tableau Desktop.
Did this article resolve the issue?