Dear All,
We would like to ask you the how to convert the excel formula to DAX as I am the new learner on Power Pivot. I really to to work out with it but it is really difficult so please help me to solve this one. I want to convert this excel formula:=SUMPRODUCT(($A$2:$A$6069=A2)*($B$2:$B$6069=B2)*($C$2:$C$6069>C2))+1 to DAX
The excel is in attached file.
Thanks
Sophanith
We would like to ask you the how to convert the excel formula to DAX as I am the new learner on Power Pivot. I really to to work out with it but it is really difficult so please help me to solve this one. I want to convert this excel formula:=SUMPRODUCT(($A$2:$A$6069=A2)*($B$2:$B$6069=B2)*($C$2:$C$6069>C2))+1 to DAX
The excel is in attached file.
Thanks
Sophanith