FLOOR() Function Error in DAX

[brianspo]

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?

[v-shex-msft · Accepted solution]

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

[brianspo]

That was it!  I imported the same data directly to my model and the function was available. 

[Aron_Moore]

Could be. My version is a bit newer and no issues. Try downloading again?

[brianspo]

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.