Forum Discussion
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...
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
