Forum Discussion
Anonymous
6 years agoNot applicable
Need help with complex DAX question
Hi all, I have written the following DAX code for filtered table in DAXStudio: EVALUATE
ADDCOLUMNS (
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE (
NATURALLEFTOUTERJOIN (
Calenda...
Greg_Deckler
Community Champion
6 years agoSample source data would really help but maybe this:
EVALUATE
ADDCOLUMNS (
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE (
NATURALLEFTOUTERJOIN (
Calendar544W,
TimesheetFacts
),
Employees01[Person],
TimesheetFacts[CMHRWRKS],
TimesheetFacts[CMHRWRKI],
Calendar544W[Date],
Calendar544W[WeekdayNum],
Calendar544W[IsPublicHoliday]
),
"Schedule",
MAXX (
FILTER (
TimesheetFacts,
Employees01[Person] = EARLIER( Employees01[Person]
),
TimesheetFacts[CMHRWRKS]
)
),
FILTER (
Calendar544W,
Calendar544W[WeekYearNum] = 202001
),
FILTER (
Employees01,
Employees01[Person] = 537 || Employees01[Person] = 125
)
),
"# Gross hrs", CALCULATE ( SUM ( TimesheetFacts[KMHRCATSH] ) )
)
ORDER BY [Date], [Person]