Forum Discussion

samto22's avatar
samto22
Frequent Visitor
6 years ago

Forecasting Flat Revenue.

Hello! I've task to calculate projects forecasting revenue. We have project amount and need to break down this amount over project period. Let's say project amount is 250k€ and project period is 24...
Need Help
samto22's avatar
samto22
Frequent Visitor
6 years ago

Hi v-eachen-msft 

 

Thank you, but seems this measure does not work (as it returns nothing) or I do not understand it.

 

Could you please explain a little bit more?

 

 

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi samto22 ,

 

Sorry, [mindate] is a new measure. I create a more direct DAX:

Measure =
IF (
    SELECTEDVALUE ( Periods[Period] ) <= MAX ( Projects[Duration, months] ),
    FORMAT (
        EDATE ( MIN ( Projects[ProjectStart] ), SELECTEDVALUE ( Periods[Period] ) - 1 ),
        "yyyy-mm"
    )
)

Here is the result and test file for your reference.

 

  • samto22's avatar
    samto22
    Frequent Visitor
    6 years ago

    Hi v-eachen-msft 

     

    Thank you for your efforts, really appreciate!

     

    Now I'm faceing problem that if I remove Periods from the visual, data are showing in one line and, for example,  can not plot forecasting on chart with Year-Month on X-axis or add to another chart to compare with another calculations. What may be the way how to solve this?