Forum Discussion
Creating Forecast based on Pipeline Values between Dates and conversion rate
Hey everyone, first of all: great support you give to the community 👏 encourages me to keep on discovering the potential of Power BI. Was searching this forum for a solution for the challenge i fa...
Hey there,
I studied some other threads with similar background and I guess SUMX/CALCULATE together with FILTER could be the solution. I added the following measure to my date table (without taking the phase into account for conversion rate):
ForecastPhase2 = Sumx( FunctionTable, CALCULATE( SUM(FunctionTable [ Value]),
FILTER( FunctionTable, FunctionTable [DatePhase2] <= Min('Datetable'[Date]) && FunctionTable [DatePhase3] >= max('Datetable'[Date])
but the measure is not even shown as column in my date table 😢
maybe power bi is a size too big and i'd better keep using excel 😬