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

Aron_Moore's avatar
Aron_Moore
Solution Specialist
8 years ago

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

 

 

  • brianspo's avatar
    brianspo
    New Member
    8 years ago

    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.