WeekEndingDate measure is showing Non WeekEndingDates for February

[Justair07]

Hi,

I'm using the following DAX to produce a WeekEndingDate:

Weekending = if(WEEKDAY('Dates'[Date],2)=7,'Dates'[Date],'Dates'[Date]-mod('Dates'[Date]-1,7)+7)

It has always worked great until a few minutes ago. I didn't change anything in the DAX or raw data.

Here is what the visual is showing for January (looks great) and another picture showing February. I also included a picture of the raw data so you can see that there are not even any Weekendingdates for Feb 05, Feb 07, etc.. I also don't have the date heiarchy enabled either:

[Justair07 · Accepted solution]

Figured it out. I must have change the X-Axis properties by mistake from Categorical to Continous.