Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Returning first working date per week

Hello Community,   Hope you are well.   I have the below calendar table. I need to add a calculated column returning the first working date per week.   Any help more than welcomed.   DateYear...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    If you want a date for each row, then try

    FirstWorkdayOfWeek =
CALCULATE (
    MIN ( 'Calendar'[Date] ),
    ALLEXCEPT ( 'Calendar', 'Calendar'[Year], 'Calendar'[Week of Year] )
)

    This takes the minimal date in the calendar table for the Year and Week of Year combination in that particular row.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,

NEw column =

if( [Date] =minx(filter(table, [Year_Week] = earlier([Year_Week]) ),[Date]) , True(), false())