Forum Discussion

sayang194's avatar
sayang194
Frequent Visitor
4 years ago
Solved

Next 3 months prediction

Hi, I have following table, and I want to create a measure that will calculate the blank fields in Column1. The calculation should be like for September= Column1[August]+Column2[September]. In this case the value of Column1[September] will be 2967.86. Then for Column1[October]= Column1[September]+ Column2[October], in this case it will 2967.86+30.23. Similarly for rest of the months. Any help will be really appreciated?

 

 

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, sayang194 ;

    You could create a measure as follow:

     

    Measure = CALCULATE(SUM([Column1])+
CALCULATE(SUM('Table'[Column2]),FILTER(ALLSELECTED('Table'),EOMONTH([date],0)=EOMONTH(MAX('Table'[date]),1))))

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, sayang194 ;

    You could create a measure as follow:

     

    Measure = CALCULATE(SUM([Column1])+
CALCULATE(SUM('Table'[Column2]),FILTER(ALLSELECTED('Table'),EOMONTH([date],0)=EOMONTH(MAX('Table'[date]),1))))

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.