cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## A table of multiple values was supplied where a single value was expected. Two Filters same table

Hello everyone,

I am trying to apply two filters to the same table ( Gifts ) both of them "Datesbetween" into a "caculatetable" but the error "<ccon>A table of multiple values was supplied where a single value was expected.</ccon>" prevents me to continue.

``````Table = FILTER(
GROUPBY(
CALCULATETABLE(
DATE(2021,04,01),
DATE(2022,03,31)
&&
DATE(2021,04,01),
date(2022,03,31))
))

2 REPLIES 2
Super User

Hey @Alejotecelec ,

for me it looks like the brackets in the datesbetween are wrong. You didn't close the brackets of the first DATESBETWEEN.

Try that one:

``````Table =
FILTER (
GROUPBY (
CALCULATETABLE (
DATESBETWEEN (
DATE ( 2021, 04, 01 ),
DATE ( 2022, 03, 31 )
)
&& DATESBETWEEN (
DATE ( 2021, 04, 01 ),
DATE ( 2022, 03, 31 )
)
),
COUNTX (
CURRENTGROUP (),
)
),
)
``````

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

Frequent Visitor

Hi Denis,

I've tried the solution and now I have this message " A function 'DATESBETWEEN' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

``````Table = FILTER(
GROUPBY(
CALCULATETABLE(
DATESBETWEEN(
DATE(2021,04,01),
DATE(2022,03,31)
)
&&
DATESBETWEEN(
DATE(2021,04,01),
date(2022,03,31)
)
),
COUNTX(
CURRENTGROUP(),
)
),
)``````