Forum Discussion
istvan_gorgey
8 years agoFrequent Visitor
Insightly with Power BI Desktop
Dear Forum Members, I'm suffering a bit with Insightly data connection. I've added PowerBI data source using the Insightly connector and now I have the possibility to define measured values. Ot...
istvan_gorgey
8 years agoFrequent Visitor
Hi Yuliana,
Thanks for the quick feedback. Yeah I tried it but it will sum all of the probability values which should be a weight instead of sum function.
So somehow I should use a cycle or of statements to have all the value as a weight.
If you have any idea please help me.
Thanks in advance!
BR, IStván
tonyinsightly
8 years agoNew Member
Hi istvan_gorgey,
Insightly includes a weighted value field [OPPORTUNITY_VALUE_WEIGHTED], so the calculation is already done for you. Drop that into your report, and you should be all set.
Cheers,
Tony J. Roma
Senior UX Technical Writer at Insightly