Excel sumif3/13/2024 ![]() I want to get that 243 Approved Hours associated with JobID 1504136 moved up one line to a PY Actual column for JobID 1732174 based on the relationship between the two tables. The second screenshot shows the date currently in Power BI. So the 243 PY Actual is now associated with JobID 1732174. I'm using the PriorYearJobID as the criteria to sum from the JobID on the tblWIP sheet. The first screenshot is of the tblJob in Excel with the PY Actual SUMIF column included. I could accomplish it in Excel by creating a SUMIF column that sums the units by job from tblWIP using the prior year JobID in the tblJob, but can't figure out how to accomplish this same result in Power BI with a measure. the prior year actual time using the two tables of data. I'm trying to create a table in Power BI that would show the current year JobID budgeted time vs. At the end of every year a new JobID is assigned to the same job (i.e AU19 JobID would be 1504136, but then for the same client AU20 JobID would be 1732174), so the tblJob also contains a column that reflects the prior year JobID associated with the current year JobID. The second table (tblJob) contains a summary of those same JobIDs. But you also can use SUMIFS to return the sum for any number criteria in a single criteria range, relying on items listed in a Criteria List. The first table (tblWIP) contains a JobID and hour units associated with that JobID with each row reflecting every time new time input is loaded for a job. Excels SUMIFS function returns the sum for virtually any number of sets of one criteria and its criteria range.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |