Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |