Calendar value

Hi Everyone,

I have a report that i need to create.

i have an excel file with a series of questions.

Example:

Question 1: Enter the duration of the challenge. User chooses two date fields (1 Jan 2022 ) to ( 4th Mar 2022 )

Question 1a : Enter the rating of the challenge. User enters low moderate high (or 1, 2, 3)

What i need to solve in Power BI.

I need to then for Jan, Feb, Mar for Question 1: give it a consistent score so

Jan-1, Feb-1 Mar-1 (if user chooses low)

I then have 10 other questions. and then i need to sum all scores in the column and take an average so i can build a heatmap

What do i need to do?

- create a calendar table first?

- link the question table to the calendar tabl?

thanks