Forum Discussion
Anonymous
7 years agoNot applicable
Simple Measure is returning an error
NewColumn3 = VAR SalesQuty = SUM(Sales[SalesQuantity]) VAR Text1 = "This month we sold " VAR Text2 = " Items" VAR Result = IF( SalesQuty > 0, Text1 & SalesQuty & Text2, "No Sales this Mont...
- 7 years ago
Anonymous you don't need VAR on RESULT line
NewColumn3 = VAR SalesQuty = SUM(Sales[SalesQuantity]) VAR Text1 = "This month we sold " VAR Text2 = " Items" Result IF( SalesQuty > 0, Text1 & SalesQuty & Text2, "No Sales this Month" )
- Anonymous7 years ago
Thank you!
parry2k
Super User
7 years agoAnonymous you don't need VAR on RESULT line
NewColumn3 = VAR SalesQuty = SUM(Sales[SalesQuantity]) VAR Text1 = "This month we sold " VAR Text2 = " Items" Result IF( SalesQuty > 0, Text1 & SalesQuty & Text2, "No Sales this Month" )
- Anonymous7 years agoNot applicable
Thank you!