Forum Discussion
Br1-981
2 years agoHelper I
Histogram with missing months
Hi,
I'm building a report using a DATA TABLE including a Date for each record.
I've created a CALENDAR TABLE using
Calendar = CALENDAR(DATE(2019,1,1), DATE(2030,12,31))and then
YEAR = YEAR('Calendar'[Date])
MONTH = MONTH('Calendar'[Date])
MONTH_SHORT = FORMAT ( 'Calendar'[Date], "MMM" )
Then I've connected the two tables and I'm trying to create a histogram but the problem is that using MONTH i have the full range across the year:
while using the MONTH_SHORT I got:
But I cannot understand why, my target is to use the MONTH SHORT but havnig the full range.
Thanks in advance
1 Reply
- ryan_mayuSuper User