Forum Discussion

barrymatharoo's avatar
barrymatharoo
Frequent Visitor
6 years ago
Solved

Resource Profiles

I have been trying to replicate an excel formula in PowerBI with mixed results. Any help would be greatly appreciated.   https://drive.google.com/open?id=1esHQOslraQ8t1H7FpzA8I8fl6gr-uuUb...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601