Forum Discussion

qbarnes's avatar
qbarnes
Helper I
5 years ago
Solved

Converting Excel Formula to DAX

Happy Tuesday,    I need help converting an excel formula to Dax.  The formula is as follows:    =RATE(([@Term]*21), -ROUND([@[Factor_Rate]]/([@Term]*21)*[@[Advance Amount]],2),([@[Advance Amo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi qbarnes ,

     

    DAX contains RATE() and ROUND() function as well.There seems to be no difference in the number of parameters. 

     

    If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business after removing sensitive data.

     

    Best Regards,
    Eyelyn Qin
    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
5 years ago

Hi qbarnes ,

 

DAX contains RATE() and ROUND() function as well.There seems to be no difference in the number of parameters. 

 

If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business after removing sensitive data.

 

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