The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How to replicate the below formula in DAX?
if the time is before 6 am in the "Section End DateTime" column then it should be of previous dates in the next column called "Prod. Date" because the previous day's night shift ends at 5:59am
in Excel I used "=IF(V2<"6:00",W2-1,W2)" formula.
Solved! Go to Solution.
Prod. Date=INT([Section End DateTime]-6/24)
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
9 | |
7 |