[SOLVED] Date range slice
I have no idea what i’m doing wrong. In my app I have a dashboard which shows me a pie chart of all my income and expenses by transaction type. I want to limit the data in this pie chart by applying a date range filter in which I can set a start date column and a end date column to a specific value.
I use two tables for this, one which has all the transactions and one which is a settings table in which I can adjust the start date and the end date column.
I tried to create a slice with the following formula:
AND(Transactions[Date of Transaction:] >= Settings[Start Date:], Transactions[Date of Transaction:] <= Settings[End Date:])
I get the following error:
Arithmetic expression ‘(REGISTRO[Fecha de transferencia:] >= SALPICADERO[Fecha Inicial:])’ does not have valid input types
I have no idea why I’m getting this error. Can anyone please tell me what I’m doing wrong and tell me how to best achieve what I want?
Many thanks in advance.