Trying to use DATEDIFF and I keep getting "In DATEDIFF function, the start date cannot be greater than the end date"... except it's not. Very irritating, I even tried to write the formula using "DATEVALUE" within the "DATEDIFF" formula which the same error.
3 Comments
- chass
Impactful Individual
Can you include the values you are getting the error with? - fbcideas_migusrNew MemberHi I am getting this error too, even though I have checked and the start dates are definitely not greater than the end dates. Did you find a resolution?
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels2 hours agoAdvocate IIINew177Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen3 hours agoAdvocate INew292Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi3 hours agoMicrosoft EmployeeNew17Views6likes0Comments