Forum Discussion

banda's avatar
banda
Regular Visitor
3 years ago
Solved

Days Comparison

I need to compare days of  3 years then month 1st Monday of the year  1st Tuesday of the year etc Then  Month of January sales 2022 , 2023 and 2024   Can any expert guide me to find a solutio...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi banda ,

     

    I suggest you to create a calendar table to help your calculation.

    Calendar =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "MonthName", FORMAT ( [Date], "MMMM" ),
    "WeekDay", WEEKDAY ( [Date], 2 ),
    "DayName", FORMAT ( [Date], "DDDD" ),
    "WeekNum",
        IF ( YEAR ( [Date] ) = 2024, WEEKNUM ( [Date], 2 ) + 1, WEEKNUM ( [Date], 2 ) )
)

    Create two matrix visuals.

     

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi banda ,

 

I suggest you to create a calendar table to help your calculation.

Calendar =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "MonthName", FORMAT ( [Date], "MMMM" ),
    "WeekDay", WEEKDAY ( [Date], 2 ),
    "DayName", FORMAT ( [Date], "DDDD" ),
    "WeekNum",
        IF ( YEAR ( [Date] ) = 2024, WEEKNUM ( [Date], 2 ) + 1, WEEKNUM ( [Date], 2 ) )
)

Create two matrix visuals.

 

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.