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 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |