Forum Discussion

rivastoday's avatar
rivastoday
Frequent Visitor
7 years ago

Help Calculating Business Working hours

Hello Team,   Even there is another post with this request I already tried but the answer didnt help me out, I am trying to calculate the working hours between 2 dates using the next formula, the i...
Need Help
TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

I'm wondering how the headers of the table provided, match to the references in your DAX formulas.

Are the DAX statements intended to create calculated columns or measures.

Do you mind, to state the expected results for the calculations.

 

Regards,

Tom

rivastoday's avatar
rivastoday
Frequent Visitor
7 years ago

Hello Thanks for the support,

 

I want to create calculated columns

 

using this formula "NetwdHours = (CALCULATE(SUM(Calendario[Working Days]),DATESBETWEEN(Calendario[Date],FP[real_Submitted],FP[Real_Closed]))-2)*9" for the first line between the 23/03/2018 and the 02/04/2018 we have 5 working days, if I subtract 2 days I only have 3 working days. Every day has 9 hours, so if I multoply the result should be 3 days * 9 hours = 27 hours (HH:MM)

 

Real_Submitted Real_ClosedExpected result
23/03/2018 16:5302/04/2018 00:063 working days * 9 hours = 27 hours (HH:MM)

 

Thanks

  • rivastoday's avatar
    rivastoday
    Frequent Visitor
    7 years ago

    Hi @v-shex-msft

     

    I saw you already solved something similar, could you please help me.

     

    Thanks,