[SOLVED] Date range slice I have no idea wha...

[Cubaine]

[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.