Forum Discussion

luizzed's avatar
luizzed
Frequent Visitor
7 years ago
Solved

MdxScript(Model) (9, 8) Erro date too small or too large

Hi,   What's wrong with this?   I have a Calendar and another fact table.   I'm creating this measure:   Test:= var last_dat = LASTDATE('Calendar'[Date]) RETURN DATE(YEAR(last_dat),MONTH(las...
Need Help
  • luizzed's avatar
    luizzed
    7 years ago

    I found the error.. There were lines only with null in the fact table, in the query i excluded this lines, and, after that, started working fine.

     

    Curious is the fact that it works even with full rows with null when you only use one function (year or month) within Date(), but if you use both, the error happens.

     

    Anyway, it's solved. Thanks!

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi luizzed ,

 

Can you share a sample file, please? Please mask the sensitive parts first. It seems fine.

 

 

Best Regards,

  • luizzed's avatar
    luizzed
    Frequent Visitor
    7 years ago

    I found the error.. There were lines only with null in the fact table, in the query i excluded this lines, and, after that, started working fine.

     

    Curious is the fact that it works even with full rows with null when you only use one function (year or month) within Date(), but if you use both, the error happens.

     

    Anyway, it's solved. Thanks!