Forum Discussion

aramirez2's avatar
aramirez2
Icon for Helper I rankHelper I
5 years ago
Solved

Previous working day column

Hi!   I need to create a previous working day column in my calendar table which has the following structure:     WorkingDay column = "1" means that we opened our store and I need for each ...
Need Help
  • aramirez2's avatar
    aramirez2
    5 years ago

    Thanks amitchandak  but your Work Date Cont column gives today date (Monday) for today record as Previous Work Day. 

     

    I got the solution. Now PrevWorkDay column gives Friday as Previous Work Day for Saturday, Sunday and Monday records.

     

     

     

     

    PreviousWorkDay = 
var a = Hoja1[Date]
RETURN CALCULATE(MAX(Hoja1[Date]); FILTER(ALL(Hoja1); Hoja1[Date] < a && Hoja1[WorkingDay] = 1))

     

     

aramirez2's avatar
aramirez2
Icon for Helper I rankHelper I
5 years ago

Hi amitchandak

 

Thanks for your answer. However your formulas does not seem to show the desired result:

 

 

 

I have already created Workday column with "1" and "0" values. This data is correct and PrevWorkDay is nearly to work properly. I would like to fill up Blank PrevWorkDay cells with the very last work day.

 

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

aramirez2 , I think, in the blog I shared I have updated nonworking dates with the last working dates 

 

Work Date Cont = if([Work Day]=0,maxx(FILTER('Date',[Date]<EARLIER([Date]) && [Work Day]<> EARLIER([Work Day]) ),[Date]),[Date])
  • aramirez2's avatar
    aramirez2
    Icon for Helper I rankHelper I
    5 years ago

    Thanks amitchandak  but your Work Date Cont column gives today date (Monday) for today record as Previous Work Day. 

     

    I got the solution. Now PrevWorkDay column gives Friday as Previous Work Day for Saturday, Sunday and Monday records.

     

     

     

     

    PreviousWorkDay = 
var a = Hoja1[Date]
RETURN CALCULATE(MAX(Hoja1[Date]); FILTER(ALL(Hoja1); Hoja1[Date] < a && Hoja1[WorkingDay] = 1))