A function in DAX for ISWHOLENUMBER may be a good way to identify leap years in date ranges among other tasks.
3 Comments
- fbcideas_migusrNew MemberISWHOLENUMBER([Number]) would be the same as [Number]=INT([Number]) If such a function were introduced, it should be called ISINTEGER so that it includes negative numbers.
- nishalitNew Member
You can do this with
[Number]=INT([Number]) - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Programmatic point-of-failure recovery for Fabric pipelines
The Fabric monitoring UI already supports Rerun → rerun from failed activity. That capability is only reachable by a human clicking in the portal. Please make point-of-failure recovery available to a...EversonElias2 hours agoRegular VisitorNew2Views0likes0CommentsEnable Managed Private Endpoints Support for Microsoft Fabric Capacities Below F64
Managed Private Endpoints in Microsoft Fabric are currently supported only on F64 and higher capacities. Customers using lower capacities, such as F8, cannot establish private connectivity to Azure s...v-tsindhu4 hours agoMicrosoft EmployeeNew6Views0likes0CommentsAccessibility bug: Notebook cell text becomes invisible under Windows 11 High Contrast mode
Any text written inside a Fabric notebook is invisible when Wndows High contrast mode is enables. This applies to cell text only (not the UI). In addition, auto-complete windows are not respecting t...abigb5 hours agoNew MemberNew3Views0likes0Comments