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
Power BI: Don't auto-SUM numeric data types
When setting column data type to numeric, Power BI defaults to automatically summing those columns. In real-world data most numeric data columns are not meant to be summed. They are sometimes primary...SevsBo10 minutes agoResponsive ResidentNew1View0likes0CommentsPower BI: keep Transform button visible during initial data load, not hidden under Load button
With regular data ingestion it would be great if the Transform Data button wasn't hidden under the Load button. Any experienced Power BI developer will first do a data transformation, not merely load...SevsBo15 minutes agoResponsive ResidentNew1View0likes0CommentsCase sensitive-insensitive option in Power BI
There should be an option in Power BI for the data in the columns to be either case sensitive or insensitive. When one deals with data involving client names or entity names, case sensitivity-sinsens...sohail_syed_moh16 minutes agoNew MemberNeeds Votes2.3KViews127likes12Comments