Cumulative total

prashantg364 — Thu, 15 Jun 2023 06:32:15 GMT

I have 2 tables

1. Target Table, 2. Achieved Table - shown below
I linked both tables by Month columns and want to visualize cumulative totals.
X-axis I need to keep the month number from the Target table
Y axis I need to keep the cumulative total both from the Target table & Achieved table

I tried to create a visual as shown below, but from the achieved table, I need data till last month but it is showing me data till the end.

Pls suggest any way to do the same

Target Table
Month	Target Productivity	Cumulative
Jan	0.09	0.09
Feb	0.16	0.25
Mar	0.63	0.88
Apr	0.57	1.45
May	0.71	2.16
Jun	1.33	3.49
Jul	1.18	4.67
Aug	1.11	5.78
Sep	1.13	6.91
Oct	1.34	8.25
Nov	1.38	9.63
Dec	1.425	11.055

Achieved Table
Month	achieved Productivity	Cumulative
Jan	0	0
Feb	0	0
Mar	1.39	1.39
April	3.08	4.48
May	0.80	5.27

Re: Cumulative total

tamerj1 — Thu, 15 Jun 2023 07:32:06 GMT

Hi prashantg364
Try to add a condition

IF ( NOT ISEMPTY ( 'achieved table' ), your expression )

Re: Cumulative total

prashantg364 — Thu, 15 Jun 2023 07:57:32 GMT

Thanks, it works

topic Re: Cumulative total in DAX Commands and Tips

Cumulative total

Re: Cumulative total

Re: Cumulative total