Days Comparison

[banda]

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 solution ?

[Anonymous · Accepted solution]

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.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...