hi Expert
i am trying to aggregate and display the sum in text input in power apps.
in the above picture, i want to aggregate housing locations between the date range.
this is not giving me the value Please help
Sum(
Filter(
'WR Housing Assignments',
StartDateTime_Column1>=Dtpicker_Startdate,
EndDateTime_Column1 <= Dtpicker_Enddate
),
'WR Housing Locations')
Further location is from different hoising location table which is a lookup file.

Report
All responses (
Answers (