Forum Discussion

Alde's avatar
Alde
Frequent Visitor
4 years ago

Show last month without selecting filter

Hello Everyone, I'm a beginner and  struggling to formulate a measure to show a specific month(or last month) in Year-to-date card when I do not select any month on filter bar. I have columns, Month...
Need Help
Tips and Tricks
Alde's avatar
Alde
Frequent Visitor
4 years ago

Hi amitchandak  

Thanks for this solution,

but the thing is I'm using the Month column of text, not actually from the calendar. 

Can I know how to relate this text Month column to the clender if I have to use month column from the calendar.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Alde ,

 

I think you can add Month column in calendar table and then relate the Table[Month] to Calendar[Month].

You can try to create a calendar table by code as below. [MonthShortName] is text format as "Jan" and [MonthName] is text format as January.

Calendar =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "MonthNum", MONTH ( [Date] ),
    "MonthShortName", FORMAT ( [Date], "MMM" ),
    "MonthName", FORMAT ( [Date], "MMMM" )
)

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.