Date, Fiscal Table

[Yrstruly2021]

I am trying to create a date table, to link it to my public holiday table. The created date table does not contain any data, please assist?

See: https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing

[Anonymous · Accepted solution]

@Yrstruly2021 
I see no problem with your model, every table was connected using the correct column. It seems you didn't use dax to create the calendar table in Power BI Desktop.

Just some insights: you could also use the following dax to create a table:

Calendar table = Calendar(Date(2020,1,1), Today())

Then create other columns using dax, for example:

Year = Year([Date])
Day = Day([Date])

Weekday name= FORMAT([Date],"DDDD")

weekday= IF(WEEKDAY([Date],2)<=5,TRUE(),FALSE())

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Yrstruly2021]

Is my data model correect in terms of relationships? https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing