Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Helper V
5 years ago
Solved

Date, Fiscal Table

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/1CBpFLkw37E5aeYSG9RXM...
General Comment
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.