Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • parry2k's avatar
    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"
    )
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you!