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
Accessibility 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...abigb29 minutes agoNew MemberNew2Views0likes0CommentsF5 for presentation mode in POWER BI DESKTOP
F5 for presentation mode in POWER BI DESKTOP. In design time when we press F5 . 1) The canvas goes to fit to screen mode. 2) Visual headers will be hidden for visual components which set to hidden in...ndaneshi2 hours agoNew MemberNeeds Votes104Views3likes2CommentsExpose Card Visual Reference Values to DAX via SELECTEDREFERENCEVALUE() or similar
Description The new Card visual introduces Reference Values and Reference Labels, which are excellent for displaying targets, benchmarks, prior periods, and other contextual metrics alongside a KPI....SEMattis3 hours agoAdvocate IIINew2Views0likes0Comments