Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have an excel formula I need to translate in DAX, anyone know how to do it?
=SUMPRODUCT(--(ISNUMBER(MATCH(B28:B199999;C28:C49999;0))))
Two columns
april
may
There can be multiple records for each
(as I continue to tear my hair out!)
Thanks All
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share some data and show the expected result.
I'm sending exampele. I think this will do the trick 🙂
https://www.dropbox.com/s/3q085s2i5o7nogu/Data.xlsx?dl=0
tnx, for help
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you, that shuld be it.
Can you just tell me how did you do Data table.
Hi,
By appending Sheet1 and sheet2. If my previous reply helped, please mark it as Answer.
HI @jest1234 ,
AFAIK, SUMPRODUCT function will multiplies ranges or arrays together and returns the sum of products. You can consider to use sumx function to get the result:
Formula = SUMX ( ALLSELECTED ( Table ), [Column1] * [Column2] )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |