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
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler23 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v23 hours agoCommunity ChampionCompleted4.2KViews75likes8Comments