Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZECOLUMNS(
'tep_projects'[tep_assignments.resource_name],
'tep_projects'[snap_date],
"CountRows", 'tep_projects'[CountRows],
"DF_", 'tep_projects'[DF%],
"CS_", 'tep_projects'[CS%],
"PPAP_", 'tep_projects'[PPAP%]
)
VAR __DS0PrimaryWindowed =
TOPN(
101,
SUMMARIZE(__DS0Core, 'tep_projects'[tep_assignments.resource_name]),
'tep_projects'[tep_assignments.resource_name],
1
)
VAR __DS0SecondaryBase =
SUMMARIZE(__DS0Core, 'tep_projects'[snap_date])
VAR __DS0Secondary =
TOPN(102, __DS0SecondaryBase, 'tep_projects'[snap_date], 1)
VAR __DS0BodyLimited =
NATURALLEFTOUTERJOIN(
__DS0PrimaryWindowed,
SUBSTITUTEWITHINDEX(
__DS0Core,
"ColumnIndex",
__DS0Secondary,
'tep_projects'[snap_date],
ASC
)
)
EVALUATE
__DS0Secondary
ORDER BY
'tep_projects'[snap_date]
EVALUATE
__DS0BodyLimited
ORDER BY
'tep_projects'[tep_assignments.resource_name], [ColumnIndex]
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |