Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Filter - Previous working day

i have this code to identify "today". is there a method i could use to also identify previous working day, ihave a coloumn that indicates if its a working day or not and returns 1,0

 

WorkingDay = if(WEEKDAY([Date],2) >=6,0,1)

Is Today =
var _max = maxx(filter('Date', 'Date'[Date] <=today() && [WorkingDay] =1),'Date'[Date])
return
Switch(True(),
[Date] = _max, "Today",
Format([Date], "DD/MM/YYYY"))

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi NewbieJono 

     

    So you are doing 2 Calculated columns? your "today" is not actually today, but working day...you want something like this?

     

    test = 
var workingDays = filter('Date', 'Date'[Date] <=today() && [WorkingDay] =1)
var today = MAXX(workingDays,[Date])
var previous = MAXX(FILTER(workingDays,[Date]<today),[Date])
return
SWITCH(TRUE(),
[Date]=today,"Today",
[Date] = previous, "Previous Working Day",
Format([Date], "DD/MM/YYYY"))

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi NewbieJono 

     

    So you are doing 2 Calculated columns? your "today" is not actually today, but working day...you want something like this?

     

    test = 
var workingDays = filter('Date', 'Date'[Date] <=today() && [WorkingDay] =1)
var today = MAXX(workingDays,[Date])
var previous = MAXX(FILTER(workingDays,[Date]<today),[Date])
return
SWITCH(TRUE(),
[Date]=today,"Today",
[Date] = previous, "Previous Working Day",
Format([Date], "DD/MM/YYYY"))

     

    • juliabot's avatar
      juliabot
      New Member
      5 years ago

      I would like to calculate two/three/four previous working days, how do I do ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi juliabot 

         

        Try it

        test = 
var workingDays = filter('Date', 'Date'[Date] <=today() && [WorkingDay] =1)
var today = MAXX(workingDays,[Date])
var previous = MAXX(FILTER(workingDays,[Date]<today),[Date])
var pre2day = MAXX(FILTER(workingDays,[Date]< previous),[Date])
return
SWITCH(TRUE(),
[Date]=today,"Today",
[Date] = previous, "Previous Working Day",
[Date] = pre2day, "Previous 2 Working Day",
Format([Date], "DD/MM/YYYY"))