Forum Discussion

laehatlav's avatar
laehatlav
Frequent Visitor
6 years ago

calculate Sum value from specific monthly value

Hello Fellow Power BI, Need help in calculating the sum value for Monthly Goal column based on specific date period. I would like to sum the value of the Montly Goal value based on the shown Cost va...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, laehatlav 

 

Based on your description, I created data to reproduce your scenario. I hope it can help you.

Table:

 

DateTable(a calculated table):

 

DateTable = CALENDARAUTO()

 

 

Relationships between two tables.

 

Then you may create a measure as follows.

 

Monthly Goal = 
IF(
    MAX('Table'[Branch Name]) = BLANK(),
    BLANK(),
    CALCULATE(
        SUM('Table'[Cost]),
        ALLSELECTED('Table')
    )
    
)

 

 

Then you may use the Date column from DateTable to filter the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.