Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

calculation error, couldn't load data for the visual

  Is there any error in this measure? It seems no syntax error, how can I make a visual with this measure?  
Need Help
Show and Tell
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi, your CONCATENATE gives you a text value and your CONVERT gives you an integer, which you can't compare together. 

     

    I think if you wrap the CONCATENATE with VALUE(), that should work.

     

    VALUE( CONCATENATE(year(TODAY ()),FORMAT(MONTH(TODAY ()),"00")) )

     

AntonioM's avatar
AntonioM
Icon for Solution Sage rankSolution Sage
4 years ago

Hi, your CONCATENATE gives you a text value and your CONVERT gives you an integer, which you can't compare together. 

 

I think if you wrap the CONCATENATE with VALUE(), that should work.

 

VALUE( CONCATENATE(year(TODAY ()),FORMAT(MONTH(TODAY ()),"00")) )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    yeah, instead I removed format and it works. Thanks