Dataset field Displaying previous month instead of current month in SSRS

I need to used a dataset field month to display current month but the expression below is giving me February instead of March? How can I adjust the expression below to return current month i.e March?

Fields!Month.Value & ", " & Fields!Year.Value


--------------------------------------------------------------------------------
ProjackAsked:
Who is Participating?
 
ProjackConnect With a Mentor Author Commented:
I found the solution I simply replace Fields!Month.Value with = MonthName(Month(Now())). And it worked. The SSAS was giving me default month in 2011 which was february but by assigning Month(now) into the MonthName function it return current month
0
 
Micheal HuntSr. Software DeveloperCommented:
If you just need the current month displayed, you can do something like add a field to the report containing month(Today) as a datasource.  Is that what you're trying to do, or do you need the date to come from a field in your dataset?
0
 
ProjackAuthor Commented:
The Fields!Month.Value  is coming from this expression in the MDX query within the dataset;
[Dim Time].[Calendar].[Month].ALLMEMBERS
But instead of Fields!Month.Value  giving me March it gives February.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
ProjackAuthor Commented:
I researched I solved the issue because I need to resolve it ASAP
0
 
ProjackAuthor Commented:
I researched I solved the issue because I need to resolve it ASAP
0
 
ProjackAuthor Commented:
I researched I came out with solution becuase I need to resolved the issue before the COB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.