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...
Thanks for the pbi file. I looked at it and it seems correct. However, instead of calculating the average for each column, is there a way for it to only take the average based on latest entries of deal size max and min? Right now it seems like it is taking the average for every row instead of only the latest one
Check it like second table. Should now be there in link.
Now instead of sumx , you might want averagex for GT.