Forum Discussion

Prabha45's avatar
Prabha45
Icon for Helper III rankHelper III
3 years ago

DAX - Selected value

Hi I wrote a measure where if is January is selected measure shows 1, february 2, so on till december. Measure = switch(selectedvalue                               (dim_table[month_name]),       ...
"DAX"
@Dax help
Advance DAX
Urgent Help with DAX
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Prabha45 

if the month name column is coming from a date table the you can try. 

CONCATENATEX ( VALUES ( 'Date'[Date].[Month] ), [Month], "," )

However, the following shall work in all scenarios 

CONCATENATEX (

VALUES ( 'Table'[Month] ),

SWITCH (

[Month],

"January", 1,

"February", 2,

etc. 

),

","

)

 

  • Prabha45's avatar
    Prabha45
    Icon for Helper III rankHelper III
    3 years ago

    Thanks that worked. I need the measure to be in integer format, but it is in Text format. I used convert to change it to integer then the output changed to 123.

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Prabha45 

      Cannot have an integer with delimiter. What exactly are you trying to achieve?

      • Prabha45's avatar
        Prabha45
        Icon for Helper III rankHelper III
        3 years ago

        I need to trigger a function app with the filters selected in Power BI as input for the function app. It has month parameter which accepts inputs as 1 or 1,2 or 1,2,3. If I use the above measure( text format) it takes the values as "1,2,3". So, I converted it to integer then it took input as 123.