Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |