cancel
Showing results for
Did you mean:
Helper II

## Counting saturday and sunday and add to friday

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?

1 ACCEPTED SOLUTION
Community Support

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

3 REPLIES 3
Community Support

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

Super User

@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]
)

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition
Helper II

My Request Release Date turns grey

Announcements