Forum Discussion

chinh_ho's avatar
chinh_ho
Frequent Visitor
3 years ago
Solved

Cumulative values per month

Hi everyone, I have a target goal sale for each saler in my company in 2022, I would like to calculate cumulativetarget line for each person. I have this picture for your reference. Please help me t...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    chinh_ho , if you have a date with help from a date table

     

    example

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    or

     

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    You can create date from month and year

     

    Date = Date([year],[month],1)

amitchandak's avatar
amitchandak
Super User
3 years ago

chinh_ho , do you have a yearly target and you want to show that cummulative

 

refer

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

chinh_ho's avatar
chinh_ho
Frequent Visitor
3 years ago

Thank you so much for your quick response. I got a solution.