Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ekramulmostaqui
Helper I
Helper I

Calculate and display cost based on the same resource and the server cost

‎08-06-2024 07:27 AM

Hi,

I need some help. I need to calculate the costs based on a data set. The dataset contains date, process and resource (table 1).

 

I need to find out how many processes are running from each resource (Table 2, Column: Resource Count) (Note: there are three resources). Then, based on the resource and server cost, I need to calculate the cost of each process (Table 2). The formula is given below:

 

cost = (2000+4000)/Resource Count

 

Explanation: The cost for each process would be devided by the resource. For example:  Resource 1 has two processes. This means that the costs (2000+4000) would be divided equally between two processes (3000).

 

It would be great if anyone could provide any solution. I need to display the below Table 2 as Table in report field except resource and server cost column.

 

Table 1:

DateProcessResourceTime (sec)
01.07.2024A146
01.07.2024A132
01.07.2024B138
01.07.2024B164
01.07.2024B128
01.07.2024C29
01.07.2024D324
01.07.2024E378
02.07.2024A180
02.07.2024A164
02.07.2024B159
02.07.2024B139
02.07.2024B141
02.07.2024C252
02.07.2024D314
02.07.2024E353
03.07.2024A116
03.07.2024A113
03.07.2024B179
03.07.2024B153
03.07.2024B134
03.07.2024C274
03.07.2024D397
03.07.2024E355
04.07.2024A155
04.07.2024A152
04.07.2024B195
04.07.2024B187
04.07.2024B155
04.07.2024C275
04.07.2024D392
04.07.2024E395
05.07.2024A151
05.07.2024A167
05.07.2024B19
05.07.2024B135
05.07.2024B142
05.07.2024C259
05.07.2024D364
05.07.2024E321
06.07.2024A162
06.07.2024A13
06.07.2024B190
06.07.2024B139
06.07.2024B149
06.07.2024C248
06.07.2024D311
06.07.2024E373
07.07.2024A130
07.07.2024A130
07.07.2024B141
07.07.2024B166
07.07.2024B192
07.07.2024C280
07.07.2024D358
07.07.2024E35

 

Table 2:

ProcessResource CountResource CostServer CostTotal Cost
A220004000((2000+4000)/Resource Count) = 3000
B220004000(2000+4000)/Resource Count = 3000
C120004000(2000+4000)/Resource Count = 6000
D220004000(2000+4000)/Resource Count = 3000
E220004000(2000+4000)/Resource Count = 3000
Message 1 of 7
527 Views
0
1 ACCEPTED SOLUTION
NaveenGandhi
Super User
Super User
In response to ekramulmostaqui

‎08-09-2024 09:58 AM

@ekramulmostaqui 

Updates PBIX has the required solution.

NaveenGandhi_0-1723222692573.png

 


If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

View solution in original post

Cost.pbix
Message 6 of 7
411 Views
6 REPLIES 6
ekramulmostaqui
Helper I
Helper I

‎08-06-2024 11:25 PM

Hi @NaveenGandhi,

Thanks for the solution. But I would like to clarify a bit about the resource count. I need to calculate how many processes are handled by a resource. The resource and server cost is equally divided by each process.

 

I have seen your solution. You have counted resources 14 and 21 for process A and B. But it should be 2. Because resource 1 is occupied by 2 processes.

Message 3 of 7
476 Views
0
NaveenGandhi
Super User
Super User
In response to ekramulmostaqui

‎08-07-2024 09:31 AM

@ekramulmostaqui 

This is bit confusing, So you need to calculate how many process is occupied by a resource, Then why do you have the process names in table 2, should'nt the table be like this for clear representation?

Resouce P Count Cost

1 2 3000
2 1 6000
3 2 3000


Thanks,

NG

Message 4 of 7
469 Views
0
ekramulmostaqui
Helper I
Helper I
In response to NaveenGandhi

‎08-08-2024 02:53 AM

Hi @NaveenGandhi,

For better understanding, I have added the resource count column in the Table 2. 

I need to show the costs incurred for each process. Therefore, I only need two columns - the process name and the total cost (the columns resource count, server cost and resource cost are additional).

 

Regards,

Ekram

Message 5 of 7
452 Views
0
NaveenGandhi
Super User
Super User
In response to ekramulmostaqui

‎08-09-2024 09:58 AM

@ekramulmostaqui 

Updates PBIX has the required solution.

NaveenGandhi_0-1723222692573.png

 


If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

Cost.pbix
Message 6 of 7
412 Views
ekramulmostaqui
Helper I
Helper I
In response to NaveenGandhi

‎08-12-2024 02:29 AM

@NaveenGandhi,

Thanks a lot. The Solution works perfectly.

Message 7 of 7
377 Views
0
NaveenGandhi
Super User
Super User

‎08-06-2024 09:01 AM

hi @ekramulmostaqui 

For the provided dataset i have made a solution. Let me know if this is what you are looking for and needs any more help.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

Cost.pbix
Message 2 of 7
495 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All