Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |