Date Table not working with relationship

I'm learning how to use PowerBi. I'm trying to use a date table. I have a sharepoint list that has items. I've setup a relationship between the date table and the Created column in the Sharepoint list. The relationship doesn't seem to work. I'm not sure what I'm doing wrong. Articles show how to create a date table but ultimately fail when showing how to use the thing.

I created a table like this:

Date = 
ADDCOLUMNS (
CALENDAR (DATE(2000,1,1), DATE(2025,12,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)

I setup a relationship like this.

When I add columns to my report the data doesn't show.

I've tried refreshing data, recreating the relationship, changing the datatype and changing the format.

As mentioned I'm new. Maybe theres a special save button I didn't notice.

Need Help

Show and Tell

ComputerHabit
6 years ago
There appears to be two different places to format data.

When using Get Data and bringing in the initial SharePoint list the Date columns come as Any\Text. I had initially left it like that and made my Date table and joined them. I initally tried changing the data type in the relationship area. That didn't have the desired effect. Only after going back to the Sharepoint list data and modifying the CreatedBy column from Text to Date did it start working.