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 like to create a measure/calculated column that present the current month base on a filter on the IsCurrentMonth Attribute (column)

Is that possible?

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

4 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

     

    To present the current month in the title of the report, you could create below measure to get the current month and put it in a card or text box or something else which can accept a measure.

    Current Month = YEAR(TODAY())&"-"&RIGHT("0"&MONTH(TODAY()),2)

    or

    Current Month = FORMAT(TODAY(),"yyyy-mm")

     

     

    For the second requirement, I'm not clear what your expected result should be. Could you explain it more clearly (maybe by using some data)?

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

    • 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
        Icon for Community Support rankCommunity 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