Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago
Solved

default filter date, Switch statement

Hello i have the follwoing code to identify today.   Is Today = Switch(True(), [Date] = Today(), "Today", Format([Date], "DD/MM/YYYY"))   is there a method to identify last working day. i do ha...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    NewbieJono , Try two columns like

     

    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"))

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi NewbieJono ,

 

Please try to change your isworkingday column to :

IsWorkingDay = IF ( WEEKDAY('DIM - Date Table'[Day],2)<6,1,0)

Then use the following column to determine the last working day:

lastworkingday = IF('DIM - Date Table'[Day] = CALCULATE(MAX('DIM - Date Table'[Day]),FILTER('DIM - Date Table','DIM - Date Table'[IsHoliday] = 1&&'DIM - Date Table'[IsWorkingDay] = 1&&'DIM - Date Table'[Day]<=Tody())),1,0)

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai