Power BI pivot- pivot with changing measure

[TBhelpneeded]

Hello  community,

I'm in search for an answer, trying to create power BI pivot,where I can calcualate with actual number of weeks in Quarter,  trying to recreate this table :

Where i useColumn - quartes (text field}

Deployment frequency items - A,B,c,... (text field)

Numbers (measure)=13 (total weeks in every Q)/ measure of actual occurencies.

What im trying to figure out is to create a measure which can recognize quarters and number of weeks that actually passed in each quarter ( its 13 for all quarters but for last one it coudl be anywhere from 1 to 13)

Im thankful for any suggestions, or if different apprach would be suitable, please  share !

[v-yueyunzh-msft]

Hi , @TBhelpneeded 

According to your description, I have the following questions about your question:

(1)Are the images you provide the result you ultimately want to show?

(2)What is the relationship between the Deployment frequency items field and the quarter?

(3)Corresponds to how each value is evaluated for example 6,5 n/a 2,6 13,0?

(4)Can you provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem?

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly