• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to convert the excel formula to DAX

Sophanith

New Member
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
 

Attachments

  • Rankx Formula in DAX.xlsx
    561.1 KB · Views: 3
Back
Top