Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have in powerbi a table that is like this:
I have a column with Time, Date and Business date. For some reason my business day is from D-1 21:00:00 to D 21:00:00.
So I want to get the business date by adding 1day to the date when time is between 21:00:00 and 23:59:59.
The column "business date" is a caculated column with this formula:
Thank you
Solved! Go to Solution.
Seems it is returning blank when day calculated by DATEADD is a weekend.
Solved it by having a calculated column with WEEKDAY, return the day of the week and my column business day is calculated with IF WEEKDAY = 6 DATEADD+2 else +1
Seems it is returning blank when day calculated by DATEADD is a weekend.
Solved it by having a calculated column with WEEKDAY, return the day of the week and my column business day is calculated with IF WEEKDAY = 6 DATEADD+2 else +1
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |