Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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(
Gifts,
DATESBETWEEN(Gifts[Gift_Date],
DATE(2021,04,01),
DATE(2022,03,31)
&&
DATESBETWEEN(Gifts[Date_Added_Donor],
DATE(2021,04,01),
date(2022,03,31))
))
,Gifts[Constituent ID],
"Total_Gifts",
COUNTX(CURRENTGROUP(),COUNT(Gifts[Gift Type]))),
[Total_Gifts] > 1)
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 (
Gifts,
DATESBETWEEN (
Gifts[Gift_Date],
DATE ( 2021, 04, 01 ),
DATE ( 2022, 03, 31 )
)
&& DATESBETWEEN (
Gifts[Date_Added_Donor],
DATE ( 2021, 04, 01 ),
DATE ( 2022, 03, 31 )
)
),
Gifts[Constituent ID],
"Total_Gifts",
COUNTX (
CURRENTGROUP (),
COUNT ( Gifts[Gift Type] )
)
),
[Total_Gifts] > 1
)
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
Follow me: twitter.com/DenSelimovic
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(
Gifts,
DATESBETWEEN(
Gifts[Gift_Date],
DATE(2021,04,01),
DATE(2022,03,31)
)
&&
DATESBETWEEN(
Gifts[Date_Added_Donor],
DATE(2021,04,01),
date(2022,03,31)
)
),
Gifts[Constituent ID],
"Total_Gifts",
COUNTX(
CURRENTGROUP(),
COUNT(Gifts[Gift Type])
)
),
[Total_Gifts] > 1
)
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
10 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |