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
Display Table[Column] instead of Column Name in Conditional Formatting Dialogs
In large-scale Power BI semantic models, it is common to have identical column names across multiple fact and dimension tables. Examples include columns such as Status, Category, Region, Employee ID,...Manickambeeie1 hour agoNew MemberNew2Views0likes0CommentsNative SAP SuccessFactors and Active Directory Connectivity for Simplified Data Integration
Having native connectors for SAP SuccessFactors and Active Directory would eliminate the need for workarounds such as notebooks, custom scripts, or complex integration setups. Users should be able...João_Cristo2 hours agoNew MemberNew3Views0likes0CommentsAllow Azure Databricks streaming tables to be mirrored into Fabric
Mirroring an Azure Databricks Unity Catalog into Fabric silently drops streaming tables. They are not greyed out, not flagged, not explained. They simply do not appear in the picker, so there is no w..._taab3 hours agoNew MemberNew5Views0likes0CommentsPower BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse4 hours agoMost Valuable ProfessionalNew12Views1like0Comments