Forum Discussion
Solved
SUMIFS equivalent for calculated column
Hi, I am attempting to recreate a simple SUMIFS formula in PowerBI. The attached picture is an example of the table I want, with the column to be calculated in red and the SUMIFS formula used for th...
Spyker Try:
Column = VAR __User = [User] VAR __Week = [Week Number] VAR __Table = FILTER('Table',[User] = __User && [Week Number] = __Week) RETURN SUMX(__Table,[Hours])
Spyker Try:
Column =
VAR __User = [User]
VAR __Week = [Week Number]
VAR __Table = FILTER('Table',[User] = __User && [Week Number] = __Week)
RETURN
SUMX(__Table,[Hours])
Wow, worked perfectly! Thanks very much for your accurate and fast response.