Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display dimension member (current month)

I have a date dimension including two attributes: IsCurrentMonth (Yes/no) and YearMonthNumber (2021-01, 2021-02) I want to present the current month (2021-06) in the title of the report and would li...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Anonymous You could try 

    SELECTEDVALUE( 'tablename'[YearMonthNumber] )

    or 

    CALCULATE(SELECTEDVALUE('tablename'[YearMonthNumber]),'tablename'[IsCurrentMonth] = "Yes")

    or 

    CALCULATE(MAX('tablename'[YearMonthNumber]),'tablename'[IsCurrentMonth] = "Yes")

     

    Regards,

    Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thanks, I would like to calculate from ther other column (IsCurrentMonth) awhich not always is the same as the "real" calender currentmonth

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Anonymous You could try 

SELECTEDVALUE( 'tablename'[YearMonthNumber] )

or 

CALCULATE(SELECTEDVALUE('tablename'[YearMonthNumber]),'tablename'[IsCurrentMonth] = "Yes")

or 

CALCULATE(MAX('tablename'[YearMonthNumber]),'tablename'[IsCurrentMonth] = "Yes")

 

Regards,

Jing