Forum Discussion
Niels_83
Nov 17, 2025Copper Contributor
power query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 ...
- Nov 17, 2025
You may use measure like
Shared := VAR TotalRevenue = SUMMARIZE ( Revenue, Revenue[category], "Revenue", SUM ( Revenue[revenue] ) ) VAR AddShares = ADDCOLUMNS ( CROSSJOIN ( TotalRevenue, Shares ), "ToTake", Revenue[category] = Shares[employee] ) VAR Filtered = FILTER ( AddShares, [ToTake] ) VAR KeepColumns = SELECTCOLUMNS ( Filtered, "Employee", [employee], "Manager", [accountmanager], "Revenue", [revenue], "Share, %", [share accountmanager] ) VAR Result = ADDCOLUMNS ( KeepColumns, "Shared", [Revenue] * [Share, %] ) RETURN SUMX ( Result, [Shared] )For Power Query only no changes are required
Niels_83
Nov 20, 2025Copper Contributor
I have separate column for year (number) and month (text). It would be great if you have measure for variance in revenue in selected year (selected with slicer) compared to year-1. And maybe even year to month (cumulative). Something like (from pivot tabel):
SergeiBaklan
Nov 21, 2025Diamond Contributor
Sorry, I didn't catch. Desired result doesn't look as PivotTable. For it we may have periods as columns, category as rows and one or two measures as aggregation for their intersection.