Counting saturday and sunday and add to friday

[xRTP]

Hello Team!

I've been doing some reports and want to transfer it to power bi, the thing is. Transactions are done during weekdays US Locale time. Already set the locale to power bi as US Locale still some dates are appearing to be on saturday or sunday. Is it possible to add the items from saturday - sunday add this to friday? Or change the date from saturday & sunday into friday?

[v-yangliu-msft · Accepted solution]

Hi  @xRTP ,

Request Release Date turns grey What does it mean, can you tell us in the form of pictures, we can help you better

Here are the steps you can follow：

1. Create calculated column.

week = WEEKDAY('Table'[Request release Date],2)

weeknum = WEEKNUM('Table'[Request release Date],2)

Column 2 =
IF(
    'Table'[week] in {6,7},
 CALCULATE(MAX('Table'[Request release Date]),FILTER(ALL('Table'),'Table'[week]=
 MAXX(FILTER(ALL('Table'),NOT('Table'[week]) in {6,7}),[week])&&'Table'[weeknum]=EARLIER('Table'[weeknum])))
 ,
   'Table'[Request release Date])

2. Result:

Best Regards,

Liu Yang

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

[Greg_Deckler]

@xRTP You could create a calculated column like:

Column = 
  SWITCH(TRUE(),
    WEEKDAY([Request Release Date])=1,[Requeest Release Date] - 2,
    WEEKDAY([Request Release Date])=7,[Requeest Release Date] - 1,
    [Request Release Date]
  )

[xRTP]

Hi @Greg_Deckler,

My Request Release Date turns grey