Forum Discussion

vanweelden's avatar
vanweelden
Frequent Visitor
3 years ago

Use this year value for next year

Hello,

I'm struggling with this one.

Is is possible to use a year value (sum measure) multiply that with an index and use this value (measure) to split (12x) over the months of the next year?

Thank you in advance.

Regards

Marcel

Need Help

3 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    3 years ago

    Hi vanweelden 

     

    Are you using date tabel in your dataset? https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables

     

    You can achieve this if you do. 

     

    Create a Total measure 

    Total = SUM(Table[Value])

     

    Create a future measure 

    Amount future = CALCULATE([Total], DATEADD('DIM Date'[Date], -1 ,YEAR))

     

    Create a new measure adding the index to the Amount future measure

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

     

    • JoeBarry's avatar
      JoeBarry
      Solution Sage
      3 years ago

      Sure, please try 

      Amount future = DIVIDE(CALCULATE([Total], PARALLELPERIOD('DIM Date'[Date], -1, YEAR)), 12)
  • vanweelden's avatar
    vanweelden
    Frequent Visitor
    3 years ago

    Hi JoeBarry 

    Thank you for your fast response!

    What i actually want to see, is that the value €4.242 is divided by 12, so each month has a value of €354.

    Is that also possible?