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 (BankHol...
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.

     

  • 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi dax ,

         

        It was counting how many dates in the 'Start Date' column existed in the BankHoliday date column in the Bankholiday table.

         

        These tables arent related. I tried something like below but it wont work

         

        CALCULATE(COUNT(vwRB_RoomUtilisation[New ]), FILTER(BankHols, BankHols[Date] >0))
         
        Thanks