Forum Discussion
Resource Profiles
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.
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
3 Replies
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/823601Hi 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
