Forum Discussion

danman71's avatar
danman71
Regular Visitor
3 years ago
Solved

Learning DAX and DAX studio

Hello All,   I have this simple DAX line EVALUATE TOPN(10, VALUES(Calendar[DayName])) This column is simply Monday, Tuesday, Wednesday, etc.. and I want to change the case to uppercase. But I c...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please try something like below.

     

    EVALUATE
TOPN (
    10,
    SELECTCOLUMNS (
        ADDCOLUMNS (
            VALUES ( 'Calendar'[DayName] ),
            "@Uppercase", UPPER ( 'Calendar'[DayName] )
        ),
        "Uppercase", [@Uppercase]
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please try something like below.

 

EVALUATE
TOPN (
    10,
    SELECTCOLUMNS (
        ADDCOLUMNS (
            VALUES ( 'Calendar'[DayName] ),
            "@Uppercase", UPPER ( 'Calendar'[DayName] )
        ),
        "Uppercase", [@Uppercase]
    )
)
  • danman71's avatar
    danman71
    Regular Visitor
    3 years ago

    This works, can you explain why you have to do

     

     

     "@Uppercase", UPPER ( 'Calendar'[DayName] )
.. snip ..
),
"Uppercase", [@uppercase]

     

     

    It looks like we are assiging the value of UPPER(calendar[dayname]) to the variable @uppercase, and then returning it at the end? Is that correct?

    And why does the table need single ' around it within the function?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Thank you for your feedback.

      UPPER(Calendar[DayName]) is an expression.

      VALUES () function needs a table or column, not expression.

      This is why I decided to select one of table contructor functions in DAX.

      I hope this helps.