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

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

      hi AntrikshSharma ,

       

      Apologies, I still need it to be similar to COUNTIF (BankHolidays,[End Date])>0) with the greater than 0. 

       

      In Power BI the End Date that refers to in the excel formula above is in table 2 and bank holiday day desc is table 1.

       

      Thanks