if you attach a sample dashboard it would have been easier.
anyways, what you can do is first load the original data from excel and link the enddate to the master caledar table (which you need to populate) or simply add two dimension; the first one that will return the month name using the monthname function and the second one will return the week number using the week function, so now in your data model you have all the needed dimensions.
then start the design by creating a pivot table with application name, release no, month and week (add them by this order) as dimensions, and add an expression with is max(RYG status) (if there are more than one value) or only (RYG status) (if it is only one value), then you need to drag in the pivot table the month dimension above the expression tab in order to have the month and week dimension horizontally instead of vertically/
