Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |