Display Current Month in Table Visualization

[Kerensky34]

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

[v-yiruan-msft]

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]

@v-yiruan-msft
Correct that the record I would like to display on the table visual

[v-yiruan-msft · Accepted solution]

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]

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