topic Re: Learning DAX and DAX studio in DAX Commands and Tips

Learning DAX and DAX studio

danman71 — Wed, 14 Sep 2022 21:01:31 GMT

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 can't get the correct syntax correct within DAX Studio

I've tried

EVALUATE TOPN(10, VALUES(UPPER(Calendar[DayName])))

which returned an error stating this can happen when a measure formual refers to a column that contains many values....

Not trying to do anything fancy here, just simply play around with functions. What am I missing?

Re: Learning DAX and DAX studio

Jihwan_Kim — Thu, 15 Sep 2022 03:13:36 GMT

Hi,

Please try something like below.

EVALUATE TOPN ( 10, SELECTCOLUMNS ( ADDCOLUMNS ( VALUES ( 'Calendar'[DayName] ), "@Uppercase", UPPER ( 'Calendar'[DayName] ) ), "Uppercase", [@Uppercase] ) )

Re: Learning DAX and DAX studio

danman71 — Thu, 15 Sep 2022 14:28:55 GMT

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?

Re: Learning DAX and DAX studio

Jihwan_Kim — Fri, 16 Sep 2022 05:31:48 GMT

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.