Forum Discussion
Sumproduct formula in PowerBI
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 ...
Ashish_Mathur
Super User
Super UserHi,
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
- Ashish_Mathur
Thank you, that shuld be it.
Can you just tell me how did you do Data table.