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.