Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |