Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How I can calculate based on hours.. for example all the sales of Friday after 10pm should be count as Monday sales
Solved! Go to Solution.
@koralillis Something like this. i think that's what you are asking for?
SWITCH(
TRUE(),
Day IN {"Saturday", "Sunday"}, "Monday",
Day = "Friday" && HourOfDay >= 22, "Monday",
Day = "Sunday", "Monday",
"WorkWeek")
@koralillis Something like this. i think that's what you are asking for?
SWITCH(
TRUE(),
Day IN {"Saturday", "Sunday"}, "Monday",
Day = "Friday" && HourOfDay >= 22, "Monday",
Day = "Sunday", "Monday",
"WorkWeek")
@koralillis , In this logic, put an additional filter of 10 AM. OF create a date column, which move you friday date after 10 AM to Monday
https://amitchandak.medium.com/power-bi-show-weekend-data-on-monday-or-friday-dab5ee201f0e
New Date = Switch(True(),
weekDay([Date],2) =5 && Timevalue([Datetime]) >time(10,0,0), [Date]+3,
weekDay([Date],2) =6 , [Date]+2,
weekDay([Date],2) =7 , [Date]+1,
[Date]
)
Now use this new date
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |