Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SUMPRODUCT with multiple filter in DAX

 Hi Experts,   Please hava a look, Is it possible to convert the bellow formula into DAX,   =IFERROR(SUMPRODUCT(--(Table1[Date]=$B44),--(Table1[Col1]=$B$1),Table1[Col2],Table1[Col3])/SUMPRODUCT(-...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Did it help? Can you mark it as an answer?

 

Best Regards,

Dale