Resource Profiles

[barrymatharoo]

I have been trying to replicate an excel formula in PowerBI with mixed results. Any help would be greatly appreciated.

PowerBIExcel

https://drive.google.com/open?id=1esHQOslraQ8t1H7FpzA8I8fl6gr-uuUb

Attached are my files as well.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[amitchandak · Accepted solution]

Please try

Across Month = CALCULATE(SUMX(filter(Sheet1,Sheet1[Start Date]<=max('Date'[Date]) && (ISBLANK(Sheet1[End Date]) || Sheet1[End Date]>=MIN('Date'[Date]))),Sheet1[Budgeted Units]/Sheet1[Date Diff])*(if(Max(Sheet1[End Date])<=max('Date'[Date]),if(min(Sheet1[Start Date])>=min('Date'[Date]),DATEDIFF(min(Sheet1[Start Date]),max(Sheet1[End Date]),day),DATEDIFF(min('Date'[Date]),max(Sheet1[End Date]),day)),DATEDIFF(min(Sheet1[Start Date]),max('Date'[Date]),day))+1))

https://www.dropbox.com/s/qtf20ms2bjeoamq/Resource%20Curves%20in%20Powerbi.pbix?dl=0

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[barrymatharoo]

Hi @amitchandak 

The solutions breaks if I have duplicate resource entries. Can you please have a look?

https://drive.google.com/open?id=1ax15kcy_g0o6gxG2GZAPBa5bmezxDeUY

My actual data has duplicate resources.

Regards