Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Excel formula to Dax

Hi,

 

Could somebody help me with translating my two excel formulas in dax?

 

I've already calculated my workingdaysflag column which already has bank holidays incorporated.

 

COUNTIF (BankHolidays,[End Date])>0)),"0",
 
NETWORKDAYS(ParameterStartDate,[End Date],BankHolidays)-1)
 
 
Thanks
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I am not clear  about your requirement, you could refer to my sample for details. If this is not waht you want, please correct me and inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi AntrikshSharma 

       

      Thanks for that. Regarding the 

      COUNTX(
    BankHolidays, 
    BankHolidays[End Date] > 0
)

      My bank holiday column just has a name for bank holiday description and if its not then Its blank. Would this be done in a different way to count instead of countx?

      . 

      • AntrikshSharma's avatar
        AntrikshSharma
        Icon for Community Champion rankCommunity Champion
        6 years ago

        You could use 

        COUNTX (
    BankHolidays,
    NOT ISBLANK ( BankHolidays[End Date] )
)

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak ,

       

      This file wont open. It says Object reference not set to an instance of an object

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous , 

        I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

        Please do mask sensitive data before uploading.

        Thanks for your understanding and support.
        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.