Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All.
Please help with tip for calculate cost allocation by months with accumulation.
Now i have this data set :
I need create visualization in Power BI - transpose data and calculate accumulation value with summarize by month.
For example :
Project life 12 month, cost will be allocate to 12 equals parts.
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Hi Dear.
No this is no helpful for me 😞
I need allocate them.
Can you post your sample data as text? I don't want to type all of that.
yup
NumberStart dateEnd dateCost
Project 1 | 01.09.2019 | 31.08.2020 | 52,3 |
Project 2 | 01.02.2019 | 31.01.2020 | 45,4 |
Project 3 | 01.04.2019 | 31.03.2020 | 46 |
Project 4 | 01.01.2020 | 31.12.2020 | 53,5 |
Project 5 | 01.07.2019 | 30.06.2020 | 51,1 |
Project 6 | 01.09.2020 | 31.08.2021 | 53,4 |
Project 7 | 01.01.2019 | 31.12.2019 | 46,7 |
Project 8 | 01.09.2020 | 31.08.2021 | 61,2 |
Project 9 | 01.03.2020 | 28.02.2021 | 52,1 |
Project 10 | 01.03.2020 | 28.02.2021 | 55,2 |
Project 11 | 01.06.2018 | 31.05.2019 | 35 |
Project 12 | 01.06.2018 | 31.05.2019 | 88 |
Project 13 | 01.02.2018 | 31.01.2019 | 46 |
Project 14 | 01.03.2018 | 28.02.2019 | 12 |
Project 15 | 01.04.2018 | 31.03.2019 | 22 |
up
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
20 | |
13 |