Answered

Select and show data between dates

(0) Share

Report

Posted on by dalacarelia_196

648

I am trying to solve this , How many BB is in the table between the dates in the table Function and to show that in a textbox . and its not working ... pls help

Table name tblFunction

Logdates    Function
2018-01-01    BB
2018-01-01    BB
2018-01-02    BB
2018-01-02    AA
2018-01-03    AA
2018-01-03    BB
2018-01-03 BB
2018-01-04 AA
2018-01-04    AA
2018-01-04    BB
2018-01-04    BB
2018-01-05    AA

Datepcik_1 "2018-01-01 "

Datepick_2 "2018-01-04"

text( Sum(Filter(tblFunction, logdates > DatePick_1.SelectedDate, logdates < DatePick_2.SelectedDate), Function),BB ) )

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

HadynM 279 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dalacarelia_196

CountIf, or CountRows depending on your requirements, are probably what you're after.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

Something like:
CountIf(tblFunction, logdates >= DatePick_1.SelectedDate && logdates <= DatePick_2.SelectedDate && Function ="BB")
Hope that helps.
Hadyn

Was this reply helpful? Yes No
Verified answer

tly 400 on at

Like
a
(0)

Report
Copy link

Link copied!
You should be able to do either:
Text( Sum(tblFunction,
logdate > DatePick_1.SelectDate,
logdates < DatePick_2.SelectDate,
function = "BB"
) )
OR
Text( CountRows(
Filter(tblFunction,
logdate > DatePick_1.SelectDate,
logdates < DatePick_2.SelectDate,
function = "BB"
)
) )
You may want to make your boolean statement include equals, if you intend on considering dates that are equal as well.

Was this reply helpful? Yes No
v-sheyu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @dalacarelia_196,

Do you want to count the records that were in between the dates and contained “BB”?

I made a test .

I created a SP list named “test2”.

Set the Text property of label1 to:

CountIf(test2,Logdates>=DatePicker1.SelectedDate&&Logdates<=DatePicker2.SelectedDate&&Function="BB")

Also, you can Set the Text property of label1 to:

CountRows(Filter(test2,Logdates>=DatePicker1.SelectedDate,Logdates<=DatePicker2.SelectedDate,Function="BB"))

Regards,

eason

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

Jippeeee thanx

Was this reply helpful? Yes No