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
Enable OneLake to Read Snowflake-Managed Iceberg Tables via Horizon Catalog
1. Current Problem Snowflake lets customers create Iceberg tables where Snowflake manages both the catalog and the storage (CATALOG = 'SNOWFLAKE', EXTERNAL_VOLUME = 'SNOWFLAKE_MANAGED'). This is th...NareJoshi4 hours agoMicrosoft EmployeeNew3Views0likes0CommentsSet SQL analytics endpoint access mode (User's identity) via REST API and Terraform
The SQL analytics endpoint enforces OneLake security only in User's identity access mode. The only documented way to choose the mode is the Security tab in the portal (Data access mode settings). Not...smorimoto8 hours agoNew MemberNew2Views0likes0Comments