I am trying to do a date subtraction as shown in the below image. I get an error message. I am trying to find out the age of store by subtracting the first transaction date from today().
How to do a date subtraction when the data source is bigquery? - I use Tableau 10.5.2 Desktop version.
are you using Datediff() with today(). Some datasources do not support the date functions Tableau allows in Desktop. You can test this by utilizing a Extract of the data source and comparing the results.