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 ...
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
Super User
Super UserThank you, that shuld be it.
Can you just tell me how did you do Data table.
- Ashish_Mathur
Hi,
By appending Sheet1 and sheet2. If my previous reply helped, please mark it as Answer.