Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |