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 should only display current Month


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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Not very clear with desc. But the following can give month Avg. Make sure you have date dimension

    MTD Sales = CALCULATE([pct],DATESMTD('Date'[Date]))
MTD Sales = CALCULATE(average([pct]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE([pct],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last MTD (complete) Sales =  CALCULATE([pct],DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
last year MTD (complete) Sales =  CALCULATE([pct],DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
    In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
    Connect on Linkedin

  • 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