Forum Discussion

brianspo's avatar
brianspo
New Member
8 years ago
Solved

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 defin...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
brianspo
New Member
8 years ago

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