Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
@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]
)