16gb and STILL not enough memory to refresh calculations within table from SQL

[Pseifert]

Hello,

I have some complex calculations in order to get the hours between punch ins/punch outs from a time clock. I just dont understand how to adjust other than moving these calculations into a sql view and then importing. Powerbi is such a memory hog and I have 16gb... I was wondering if there is a better calculation or way to write these to free up the amount of memory on refresh prior to attempting in SQL. Maybe there is something that I am missing. Is there a way to move these calculations away from the table that is being refreshed??

Col1 =
CALCULATE (
MIN ( NorthtecPunchOrigin[Index] ),
FILTER (
ALLEXCEPT ( 'NorthtecPunchOrigin', NorthtecPunchOrigin[PERSONNUM] ),
NorthtecPunchOrigin[Index] > EARLIER(NorthtecPunchOrigin[Index])
&& NorthtecPunchOrigin[INOUT] = 0
)
)

Col2 =
LOOKUPVALUE (
NorthtecPunchOrigin[Date/Time],
NorthtecPunchOrigin[Index], NorthtecPunchOrigin[Col1]
)

Col3 =
IF (
NorthtecPunchOrigin[INOUT] = 1,
DATEDIFF ( NorthtecPunchOrigin[Date/Time], NorthtecPunchOrigin[Col2], MINUTE),
BLANK ()
)

the FT employee table is an antijoin so that they are filtered out of PunchOrigin

[Greg_Deckler · Accepted solution]

Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[Pseifert]

@Greg_Deckler Thanks for the reply, looks good and will attempt but I am unsure how to apply to this situation with Date/Time rather than just dates in the examples provided