Forum Discussion

dmbd1904's avatar
dmbd1904
Helper III
6 years ago

Cumulative Measure Using Other Measures

Hi, I've been struggling with this one for a few hours and would really appreciate some help...   I have the below table (In the image). 'The Forecast Cost' is a column. The other measures are incl...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

dmbd1904 ,

If total cost have no data when forecast data is there

Combined = CALCULATE(SUM('Cairns Home Construction$Job Ledger Entry'[Total Cost]))+[Starting Point]

else
Combined = CALCULATE(if(max('Calendar'[Month])<StartDate,SUM('Cairns Home Construction$Job Ledger Entry'[Total Cost]),0))+[Starting Point]

dmbd1904's avatar
dmbd1904
Helper III
6 years ago

Hi amitchandak , thanks for your reply.

 

I'm struggling to execute what you have suggested. I've tried the changing the 'Combined' measure to the below but this hasn't worked (See the image).

 

Combined =
var StartDate = [Earliest Month with Forecast]
Return
IF(AND(NOT(ISBLANK(CALCULATE(SUM('Commercial Forecasts'[Forecast Cost])))),ISBLANK([Starting Point])),
CALCULATE(SUM('Cairns Home Construction$Job Ledger Entry'[Total Cost]))+[Starting Point],
CALCULATE(if(max('Calendar'[Month])<StartDate,SUM('Cairns Home Construction$Job Ledger Entry'[Total Cost]),0))+[Starting Point])
 
  • dmbd1904's avatar
    dmbd1904
    Helper III
    6 years ago

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      dmbd1904 ,Can you share sample data and sample output in table format?

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      6 years ago

      Hi,  dmbd1904 

      Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

       

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