Date hierarchy weekday

[azaterol]

Hey everybody,

how can I include the weekdays in my hierarchy?

Actually I got this view. In my matrix I also need the weekdays like monday, tuesday, wednesday, etc.

How can I do this? You have an idea ?

Thank you

[v-rzhou-msft]

Hi @azaterol ,

In additon to SpartaBI's reply, I think you can try CALENDAR() or CALENDARAUTO() function and use functions YEAR(), MONTH(),DAY() and WEEKDAY() ,FORMAT([Date],YYYY/DDDD/MMMM) to create custom date table.

DimDate code should look like as below.

DimDate = 
ADDCOLUMNS (
    CALENDAR ( DATE ( 2019, 01, 01 ), DATE ( 2022, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "MonthLongName", FORMAT ( [Date], "MMMM" ),
    "Day", DAY ( [Date] ),
    "Weekday", WEEKDAY ( [Date], 2 ),
    "WeekdayName", FORMAT ( [Date], "DDDD" )
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@azaterol this is the auto date time table, you can edit it. As a best practice you want to create your own custom date table with everything you need.
Please refer to this article: https://www.daxpatterns.com/standard-time-related-calculations/

Read it carefully and It will give you what you need.

      

Showcase Report – Contoso By SpartaBI