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.

     

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