Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would simply like the difference or the month's total sales by month, and not a cummulative figure. For example, I am currently getting the following output:
Revenues Received | MONTH |
$9,061,289.66 | 11 |
$8,924,656.07 | 10 |
$7,099,541.62 | 9 |
$5,301,671.96 | 8 |
$3,804,197.98 | 7 |
What I would Like is:
Revenues Received | MONTH |
$136,633 | 11 |
$1,825,114.45 | 10 |
$1,797,870 | 9 |
$1,497,474 | 8 |
$3,804,197 | 7 |
The ACTUAL Sales AMOUNT by Month and not a cummlative total.
Solved! Go to Solution.
I had trouble getting this to work. I think its because the months I had were formed through a number of revenue/expense items. I did indeed get the correct totals in the column, but b/c the consists of numerous expense items, the numbers cumulate.
I was able to get what I desired with this equation:
Hi @bw70316
Create columns
Column = CALCULATE(SUM(Sheet4[Revenues Received]),FILTER(ALL(Sheet4),[MONTH]=EARLIER(Sheet4[MONTH])-1)) Column 2 = [Revenues Received]-[Column]
You could change the decimal palces.
In your example, $1,825,114.45 should set 2, others should set 0, but one column only support set one kind value, so i set 2 for all.
Best Regards
Maggie
I had trouble getting this to work. I think its because the months I had were formed through a number of revenue/expense items. I did indeed get the correct totals in the column, but b/c the consists of numerous expense items, the numbers cumulate.
I was able to get what I desired with this equation:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
88 | |
74 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |