Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

date table with month name

I am creating a date table using DAX.   Every thing works except for the Month Names.  It is as if it is random.    This is the same method for formatting date names as seen on a YouTube video.  ...
ac-pbi's avatar
ac-pbi
Frequent Visitor
3 years ago

Having a similar issue: Power BI is not picking up the correct month value, it's offset by a month which makes no sense:

Open to ideas about how to solve!

Rudy_D's avatar
Rudy_D
Icon for Resolver I rankResolver I
3 years ago

hey ac-pbi ,

 

Format() function sees your Month number as Date. Number 1 converted to date format is 12/31/1899. Thats why you have Dec.

You should use FORMAT() on your date column.

 

Regards,

 

Rudy