Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Issues with DAX if statement

I dont really know why I am getting an error message right here:

 

Measure =
IF(
    MIN('IMTT: MASTER TABLE'[Year_Month]) = "2023/01",
    VAR YTD_Sales =
    CALCULATE(SUM('IMTT: MASTER TABLE'[ACT Sales 2022]),'IMTT: MASTER TABLE'[Year_Month] = "2023/01"),
    10000)
 
Error message: The syntax for ',' is incorrect. (DAX(IF( MIN('IMTT: MASTER TABLE'[Year_Month] = "2023/01", VAR YTD_Sales = CALCULATE(SUM('IMTT: MASTER TABLE'[ACT Sales 2022]),'IMTT: MASTER TABLE'[Year_Month] = "2023/01"),10000))).
Need Help
  • johnt75's avatar
    johnt75
    3 years ago
    YTD ITR Actual 2022 =
IF (
    MIN ( 'IMTT: MASTER TABLE'[Year_Month] ) = "2023/01",
    VAR YTD_Sales =
        CALCULATE (
            SUM ( 'IMTT: MASTER TABLE'[ACT Sales 2022] ),
            'IMTT: MASTER TABLE'[Year_Month] = "2023/01"
        )
    RETURN
        YTD_Sales,
    10000
)

3 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    You've got a variable without a return statement. You don't need the variable so just delete "VAR YTD_Sales ="

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for your answer. I added a return statement but I still get the error.

       

      • johnt75's avatar
        johnt75
        Super User
        3 years ago
        YTD ITR Actual 2022 =
IF (
    MIN ( 'IMTT: MASTER TABLE'[Year_Month] ) = "2023/01",
    VAR YTD_Sales =
        CALCULATE (
            SUM ( 'IMTT: MASTER TABLE'[ACT Sales 2022] ),
            'IMTT: MASTER TABLE'[Year_Month] = "2023/01"
        )
    RETURN
        YTD_Sales,
    10000
)