Forum Discussion

reendzz98's avatar
reendzz98
Icon for Helper I rankHelper I
4 years ago
Solved

Displaying current month

I need help to display Month if Measure_currentMonth = 1  
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

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

reendzz98's avatar
reendzz98
Icon for Helper I rankHelper I
4 years ago

Hi amitchandak 

Thank you for your reply. 

 

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

reendzz98 , if you have month and Year

 

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

 

only month

 

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