Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 to calculate it. Thank you so much
Solved! Go to Solution.
@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)
@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)
Hi amitchandak,
Thank you so much for your response. I can not use SUM function, because it is a single value. For example : Target sale in DimSaler in 2022
Micheal: $100,000
Jack: $120,000
My purpose is to have a cumulative target line by month to compare with actual sale.
Please help me calculate it. I also have a date table in my data model.
Thank you
@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-C...
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you so much for your quick response. I got a solution.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!