Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
Hi,
I am trying to see the difference in days between when we are expecting to receive a shipment and the date the shipment actually arrives. The calculated column below is showing values correctly for shipments that are received on time (results 0 if dates are a match) or late (example: Expected Date is 04/26/2023 and Received Date is 05/01/2023 result is 3). However, for shipments that are received earlier then the Expected Date, the result is always showing -1. Is there something wrong with the formula below?
Date Difference = CALCULATE(COUNTROWS('Calendar'),FILTER('Calendar',WEEKDAY('Calendar'[Date],2)<6),DATESBETWEEN('Calendar'[Date],'DataTable'[Expected Date],'DataTable'[Received Date]))-1
Hello @JenWilson ,
check this video, it helped me with a similar case.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |