DAX to get Month() and format() as "MMMM"

[Chriswyy]

Dear guys,

I just started to learn Power BI and try to make a calendar table using DAX.

Everything is fine at the beginning, however when I try to format the month as "MMMM", it returns only December and January.

Anything wrong with my DAX input ??

[jdbuchanan71]

Are there maybe spaces on the end of the ones that are not returning a value? Instead of "30 days" it is "30 days "?

Add a column that is just the LEN.  They should all be 7.

Length = LEN ( Coursera__Inventory[RestockingFrequency] )

[jdbuchanan71]

Just read the days at the beginning of the sring and add that to the LastRestocked like this.

Next Restock = 
VAR _Days = LEFT (
            Coursera__Inventory[RestockingFrequency],
            FIND ( " ", Coursera__Inventory[RestockingFrequency] ) - 1
        )
RETURN 
CONVERT ( Coursera__Inventory[LastRestocked] + _Days, DATETIME )

[Chriswyy]

I can understand the way of your doing, but whats wrong with my input ??

I wanna explore as much DAX as possible, because i'm current learning.

Based on the nested ifs, by right the DAX should return me a value for each row,

but why some rows are NULL, even if the logical test is True? 

[Chriswyy]

@jdbuchanan71 

Sry, I have another question again. Also about date.

Something wrong with my nested if ??

[jdbuchanan71 · Accepted solution]

@Chriswyy 

Try it like this.

Month_MMM = FORMAT([Date],"MMMM")