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

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