Displaying current month

[reendzz98]

I need help to display Month if Measure_currentMonth = 1

[Ashish_Mathur · Accepted solution]

Hi,

In the filter pane, apply a filter with a criteria of 1.

[amitchandak]

@reendzz98 ,

You can have a column in date table for the current month

current flag= if(eomonth([Date]) = eomonth(Max(Table[Date]),0) , 1, 0)

then you can use as a filter

Calculate( Sum(Table[Value]), filter (Date, date[current flag] =1))

You can also refer

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...

[reendzz98]

Hi @amitchandak 

Thank you for your reply. 

What if I only have the columns for the month but no columns for date?

[amitchandak]

@reendzz98 , if you have month and Year

Date = datevalue("01-"&[Month] & "-" & [Year])

only month

Date = datevalue("01-"&[Month] & "-" & Year(Today()) )