cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freiburgc Regular Visitor
Regular Visitor

Calucation of holidays based 3 columns, date, vacation demanding, daily targe hours

Hello Everybody,

 

Please I need your help again.

 

I want to calculate holidays based on four columns.

  1. Vacation demanding (hours)
  2. Daily target hours
  3. Date
  4. Name

Data base:

Structure_Holidays.png

The basic calculation is Vacation demanding (Hours) / Daily target hours for each Name.

 

Solution in the end:

 

Solution.png

 

 

The problem is that I need the value “Daily target hours” just once and based on the first date, which contains a Value > 0 in the column “Daily target hours”.

Does somebody has a solution for my problem?

 

I hope I have explained my problems understandable. If not, please ask!

 

Thanks for your help!

Chris

2 REPLIES 2
heimig New Member
New Member

Re: Calucation of holidays based 3 columns, date, vacation demanding, daily targe hours

Hi Chris,

you could use a second table with "name" and "daily target hours" and then put it in a relationship with your first table.

 

Regards

Peter

Highlighted
suryaburaboyina Frequent Visitor
Frequent Visitor

Re: Calucation of holidays based 3 columns, date, vacation demanding, daily targe hours

Hi,

 

First sum both the hour columns and minus daily hours from vacations. then convert it into days using dax.

 

Below is the expected result as per my understanding.

 

holidays.PNG

 

please mark if it is correct.

Thanks,

Surya Teja

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 91 members 1,722 guests
Please welcome our newest community members: