Forum Discussion
Getting Average based on Latest entry
Hi everyone, I have a dataset that looks like this What I am trying to do is create a measure in PowerBI to get the Average Deal Size for a company. Basically taking Deal Size min+ deal size...
put _min and _max in [ ]
Hi amitchandak
Is this for the bottom line after the "Divide" function? I put them in [ ] like so
divide([_Min]+[_Max],(if(isblank[_Max]),0,1)+if(isblank([_Min]),0,1)))but am still receiving the same errors