Hello! I have a question.
I am working on app where i am adding entries each day of how much time i have been working etc. But now when the list of entries is starting to build up, the app takes longer and longer to load and so on. So I do want to try to simplify some expressions that i know is working a lot.
Like this one that collects time spent on different tasks during weekends within a month range.(this is later seen in a monthly overview together with all the other collections )
CONCATENATE(
"Drive: " , TOTALHOURS(
Sum(
Select(
LogWorkHour[Total Time],
AND(
[CategoryRef] = ("Weekend Drive") ,
[Datum]>=EOMONTH([_THISROW].[Datum] ,-1)+1,
[Datum]<=EOMONTH([_THISROW].[Datum] ,0)
)
)
)
),
" Work: ", TOTALHOURS(
Sum(
Select(
LogWorkHour[Total Time],
AND(
[CategoryRef] = ("Weekend Work") ,
[Datum]>=EOMONTH([_THISROW].[Datum] ,-1)+1,
[Datum]<=EOMONTH([_THISROW].[Datum] ,0)
)
)
)
),
" Support: ",
TOTALHOURS(
Sum(
Select(
LogWorkHour[Total Time],
AND(
[CategoryRef] = ("Weekend Support") ,
[Datum]>=EOMONTH([_THISROW].[Datum] ,-1)+1,
[Datum]<=EOMONTH([_THISROW].[Datum] ,0)
)
)
)
),
" Total hours: ",
TOTALHOURS(
Sum(
Select(
LogWorkHour[Total Time],
AND(
OR([CategoryRef] = ("Weekend Work") ,
[CategoryRef] = ("Weekend Drive"),
[CategoryRef] = ("Weekend Support")),
[Datum]>=EOMONTH([_THISROW].[Datum] ,-1)+1,
[Datum]<=EOMONTH([_THISROW].[Datum] ,0)
)
)
)
)
)
Any ideas??