Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure error

Hi Experts    Cannot see how to fix the following DAX.... Measure 3 = VAR _User = CONCATENATE( CONCATENATE( "(", CONCATENATE( "India", ")") ...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    just put the ; after the closing bracket around India:

     

    Measure 3 =
    VAR _User =
       CONCATENATE(
            CONCATENATE(
            "(",
            CONCATENATE(
                "India",
                ");")
        ),
        CONCATENATE(
            "[",
            CONCATENATE(
                004,
                "]")
        ))
    RETURN

    _User
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

there doesn't seem to be anything wrong, i copied it into PBI and it works:

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Doleray85 how do i amend the above to include a ; between (india) and [4] so end result is (india);[4]

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      just put the ; after the closing bracket around India:

       

      Measure 3 =
      VAR _User =
         CONCATENATE(
              CONCATENATE(
              "(",
              CONCATENATE(
                  "India",
                  ");")
          ),
          CONCATENATE(
              "[",
              CONCATENATE(
                  004,
                  "]")
          ))
      RETURN

      _User