Forum Discussion
FLOOR() Function Error in DAX
I'm noticing that the FLOOR() function in a calculated column appears as if the function isn't defined. If I use CEILING() I'm given autocompletion prompts, but FLOOR() displays as if it isn't defined:
However the function does work (this returns zero when used in a card).
I'm on the latest version (2.59.5135.781 64-bit (June 2018)). Is this a bug?
HI brianspo,
Have you test with directquery mode? If this is a case, they are lots of functions not allow to use in direct query mode, please consider to use measure to instead.
Regards,
Xiaoxin Sheng
4 Replies
Could be. My version is a bit newer and no issues. Try downloading again?
It looks like yours is a later release (.421 vs. my .721) and when I download again that's the version I get.
I tried again after downloading/reinstalling with the same results.
HI brianspo,
Have you test with directquery mode? If this is a case, they are lots of functions not allow to use in direct query mode, please consider to use measure to instead.
Regards,
Xiaoxin ShengThat was it! I imported the same data directly to my model and the function was available.
