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

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