Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How do we tackle this issue... datediff calculate 0 where both dates are same.
Date Start | Date End |
11 October 2021 | 11 October 2021 |
DATEDIFF([DATE START], [DATE END], DAY)
Result "0"
Solved! Go to Solution.
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
@mohammadyousaf what value do you expect? Since its the same day there is no difference in value. If you want that same day displayed as one than try:
if (DATEDIFF([DATE START], [DATE END], DAY))= 0, 1, DATEDIFF([DATE START], [DATE END], DAY))
Hope that helps.
Best.
Thank you, I guess IF workaround should be ok, let me try it.
In our line of business... it is calculated as working day regardless of working hours.
I am trying to find a way where one day is included in the calculations of two dates... even if dates are apart, I miss the first day as working day
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |