Financial measure estimated values but actual before that

[Bokazoit]

Is it possible to build a measure that asks for the earliest period within the current estimat

VAR MinimumPeriod = MIN(FactEstimat[DatePeriod])

Then the measure shows FactFinance[Actual] before that MinimumPeriod and Estimated values after that Period. Somthing like this:

ActualAndEstimat = IF (Period < MinimumPeriod, FactFinance[Actual], FactFinans[Estimate] )

I have tried the above but does not seem to work

[amitchandak · Accepted solution]

@Bokazoit , Try like

VAR MinimumPeriod = MINX(allselected(FactEstimat) , FactEstimat[DatePeriod])

return

IF (max(Table[Period]) < MinimumPeriod, Sum(FactFinance[Actual]), Sum(FactFinans[Estimate])  )