Forum Discussion
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?
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")) )
2 Replies
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")) )