Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Drcpaaaa
Regular Visitor

Target per shift

Hello guys 

i have a model to calculate incentive for sales based on target prr shift 

so i have tables for fingerprint attendance and daily target per store and sales for emp and store 

 

what i need to do is create a measure to distribute store daily target between employees according to predefined shifts 

For example i have store 

one emp come at 10 am to 5pm , the second one at 12 pm to 8 pm , the third one at 2 pm to 10 pm 

and the first shif in store begins at 10 am till 2 pm 

The second shift begins at 2 pm till 10 pm 

 

so for the first emp he will get 100% of store target till 12 pm then 50% till 2 pm then 33% till 5 pm and so on 

 

so any help 

thanks 

2 REPLIES 2
AnkitKukreja
Super User
Super User

Hi @Drcpaaaa 

 

Can you share the sample data and the expected solution so I can have a look at it?

 

Book Time with me.

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

hello AnkitKukreja,

thank you very much for your reply 

i have attached pic from my model the first one is daily target per store and second one is from attendence system 

what i need ( hoping ) to attach daily target for useris 15218 if he shows fingerprint and please note that type 1 for entry and 2 for exit as follows : 

* store morning shift start from 9 am to 3 pm and eveimng shift starts from 3 pm to 11 pm

* anyone came in the moring shift will be attached to morning shift ( if two will distributed equally ) 

 

thanks 

 

target.jpgfingerprint.jpg

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors