Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago

Date hierarchy weekday

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.             ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.