excel formula to dax

2 Topics

Convert Excel Formula to DAX
Could someone please help me convert this excel formula to DAX syntax? =IF([@ARDivisionNo]="08", "Avertx Billing",IF([@[Current Product Line']]]="SAAS","SAAS Billing",IF([@[Current Product Line']]]="SUBS","SAAS Billing",IF([@[Current Product Line']]]="PERP","Perpetual Billing",IF([@[Current Product Line']]]="BDSW","Bundled Software Billing","Hardware Billing"))))) Thanks!!
Solved
Anonymous
2 years ago Place DAX Commands and Tips
715Views
0likes
2Comments
Excel formula to Dax
Hi All need help in converting below Excel formula to Dax =SUMPRODUCT((source[Job Registered Date]>=(EOMONTH(E7,-1)+1))*(source [Job Registered Date]<=(EOMONTH (E7,0)))*(source [engine type]=D11)*(source[LMP]=C8))
Solved
Anonymous
2 years ago Place DAX Commands and Tips
1.6KViews
0likes
2Comments