Issue While Creating the Table with DAX Formula

[SanjeevKumar]

Hi,

I Found a BUG while creating the Date Table with Dax Formula. Please find the details below.

After Creating the table, I tried to modify the name of the Column from "YEAR" (Which is in Caps letters) to "Year" (Small Letters) and I am getting an alert as "The column 'Year' in table 'Date' has invalid bindings specified".

Please solve this and you can find the DAX formula which was used by me for creating the table.

Date =

VAR vCalender =

CALENDARAUTO( )

VAR BaseCalenderColumns =

GENERATE(

vCalender,

VAR vBaseDate = [Date]

VAR vDay = DAY(vBaseDate)

VAR vMonth = MONTH(vBaseDate)

VAR vYearDate = YEAR(vBaseDate)

VAR vWEEK = WEEKNUM(vBaseDate)

VAR vWeekNo = WEEKDAY(vBaseDate,2)

VAR VQtr = QUARTER(vBaseDate)

Return ROW(

"YEAR", vYearDate,

"Month", vMonth,

"Month_Name", FORMAT(vBaseDate, "mmmm"),

"Day", vDay,

"Day_Name", FORMAT(vBaseDate, "dddd"),

"Day of Week", vWeekNo,

"Week_No", vWEEK,

"Quarter", FORMAT(vBaseDate, "\QQ"),

"Month_Year", FORMAT(vBaseDate, "mmm YY"),

"MonthYearNo", vYearDate*100+vMonth

)

)

Return

BaseCalenderColumns

[SanjeevKumar]

[email protected]

[v-chuncz-msft]

@SanjeevKumar 

The issue is reported internally and I will keep you posted with any updates.

CRI 249298503

[v-chuncz-msft]

@SanjeevKumar 

We’ve identified the issue and this will be fixed in a future release of Desktop. For now, as a workaround, you can change the name to something else and then change it back to "Year".

[SanjeevKumar]

@v-chuncz-msft Thank You