Forum Discussion
Solved
Displaying current month
I need help to display Month if Measure_currentMonth = 1
Hi,
In the filter pane, apply a filter with a criteria of 1.
4 Replies
Hi,
In the filter pane, apply a filter with a criteria of 1.
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
Hi amitchandak
Thank you for your reply.
What if I only have the columns for the month but no columns for date?
reendzz98 , if you have month and Year
Date = datevalue("01-"&[Month] & "-" & [Year])
only month
Date = datevalue("01-"&[Month] & "-" & Year(Today()) )
