Forum Discussion

Kerensky34's avatar
Kerensky34
New Member
6 years ago
Solved

Display Current Month in Table Visualization

I have the data in the following table  But I want the table Visualization to only show the Current and NOT the average of the other Months with out a filter This is avegrage of 4 moths but s...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi  Kerensky34 ,

    You can create one measure for it just like the one in below screenshot. And I just create one sample PBIX file, you can find full details in it.

    CurrentMonth =

    VAR a =

        IF (

            YEAR ( MAX ( 'Product Info'[Record Month] ) ) = YEAR ( TODAY () )

                && MONTH ( MAX ( 'Product Info'[Record Month] ) ) = MONTH ( TODAY () ),

            MAX ( 'Product Info'[Record Month] ),

            BLANK ()

        )

    VAR b =

        CALCULATE (

            MAX ( 'Product Info'[Record Month] ),

            FILTER ( 'Product Info', NOT ( ISBLANK ( a ) ) )

        )

    RETURN

    b

     

    If the above measure formula is not applicable in your scenario, please provide the related table structure and some sample data(exclude sensitive data).

     

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Kerensky34 ，

I'm not very clear about your requirement. What is your expected results? Could you please provide some samples? If the record in below screenshot is that you want to display on the table visual in the end?

 

Best Regards

Rena

  • Kerensky34's avatar
    Kerensky34
    New Member
    6 years ago
    Anonymous
    Correct that the record I would like to display on the table visual
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi  Kerensky34 ,

      You can create one measure for it just like the one in below screenshot. And I just create one sample PBIX file, you can find full details in it.

      CurrentMonth =

      VAR a =

          IF (

              YEAR ( MAX ( 'Product Info'[Record Month] ) ) = YEAR ( TODAY () )

                  && MONTH ( MAX ( 'Product Info'[Record Month] ) ) = MONTH ( TODAY () ),

              MAX ( 'Product Info'[Record Month] ),

              BLANK ()

          )

      VAR b =

          CALCULATE (

              MAX ( 'Product Info'[Record Month] ),

              FILTER ( 'Product Info', NOT ( ISBLANK ( a ) ) )

          )

      RETURN

      b

       

      If the above measure formula is not applicable in your scenario, please provide the related table structure and some sample data(exclude sensitive data).

       

      Best Regards

      Rena