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
Add a link to Fabric Capacity Metrics in Monitoring > Capacities
The new Capacities page in Monitoring is very useful. Thank you for this improvement. I would like to suggest adding a direct link to Fabric Capacity Metrics from the Monitoring > Capacities page. ...ahmet_ercanli4 hours agoNew MemberNew9Views0likes0CommentsFabric App (Rayfin): support for Service Principal authentication
Hi, about Fabric Apps it is very important to implement and release the Service Principal authentication as soon as possible, in order to evolve related Fabric solutions towards enterprise ones! Ma...pmscorca5 hours agoPost ProdigyNew9Views4likes0CommentsDatabricks Autoloader equivalent for Fabric Lakehouse
We need something low code close to autoloader of databricks in Fabric, which is built on top of structured streaming, that can load data incrementally from lake files in ADLS/One Lake into lakehous...Gaurav_Batta6 hours agoNew MemberNeeds Votes1.4KViews30likes3CommentsAllow Power Query to temporarily skip a step (turn a query step on and off)
It would be nice to have an option/button/toggle that would allow the query to temporarily skip a step. For example, if you are testing a query it would be nice to be able to toggle a filter step on...EHA_SD8 hours agoAdvocate IVNew5Views0likes0Comments