cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Merge two line chart with different timeline

I have a despatch plan from Jan to May & also the cash received data from Feb to Jun (Assuming 30 days credit period post despatch). Now in actual it has happened that some of the despatches of Apr month may get preponed and despatched in Feb. So the cash received for those items is at actual i.e. Desp Date + 30 Days. i.e. in Mar.  Now if I want to plot both the graphs on cumulative value the time scale is different for both the values. So how to show them under one chart

 Month Desp Plan Cumulative Desp Jan 20 20 Feb 15 35 Mar 30 65 Apr 25 90 May 10 100 TOTAL 100
1 ACCEPTED SOLUTION
Community Support

Here are the steps you can follow：

1. Create calculated table.

``````Table2 =
CALENDAR(
DATE(
2023,1,1),
DATE(
2023,12,31))``````

2. Create calculated table.

``````True =
var _table1=
SUMMARIZE(
'Table2','Table2'[Year],'Table2'[Month],
"Cumulative1",
SUMX(
FILTER(ALL('Table'),
YEAR('Table'[Desp Plan])='Table2'[Year]&&
MONTH('Table'[Desp Plan])='Table2'[Month]),[Planned Value]),
"Cumulative2",
SUMX(
FILTER(ALL('Table'),
YEAR('Table'[Desp Actual])='Table2'[Year]&&
MONTH('Table'[Desp Actual])='Table2'[Month]),[Desp value]))
var _table2=
_table1,"Cumulative Plann",
IF(
[Cumulative1]=BLANK(),BLANK(),
SUMX(FILTER(_table1,[Year]=[Year]&&[Month]<=EARLIER([Month])),[Cumulative1])))
return
_table2,"Cumulative Desp",
IF(
[Cumulative2]=BLANK(),BLANK(),
SUMX(FILTER(_table1,[Year]=[Year]&&[Month]<=EARLIER([Month])),[Cumulative2])))``````

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 REPLIES 3
Community Support

Here are the steps you can follow：

1. Create calculated table.

``````Table2 =
CALENDAR(
DATE(
2023,1,1),
DATE(
2023,12,31))``````

2. Create calculated table.

``````True =
var _table1=
SUMMARIZE(
'Table2','Table2'[Year],'Table2'[Month],
"Cumulative1",
SUMX(
FILTER(ALL('Table'),
YEAR('Table'[Desp Plan])='Table2'[Year]&&
MONTH('Table'[Desp Plan])='Table2'[Month]),[Planned Value]),
"Cumulative2",
SUMX(
FILTER(ALL('Table'),
YEAR('Table'[Desp Actual])='Table2'[Year]&&
MONTH('Table'[Desp Actual])='Table2'[Month]),[Desp value]))
var _table2=
_table1,"Cumulative Plann",
IF(
[Cumulative1]=BLANK(),BLANK(),
SUMX(FILTER(_table1,[Year]=[Year]&&[Month]<=EARLIER([Month])),[Cumulative1])))
return
_table2,"Cumulative Desp",
IF(
[Cumulative2]=BLANK(),BLANK(),
SUMX(FILTER(_table1,[Year]=[Year]&&[Month]<=EARLIER([Month])),[Cumulative2])))``````

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Frequent Visitor
 Description Desp Plan Planned Value Desp Actual Desp value Assy 1 Jan-23 100 Jan-23 100 Assy 2 Jan-23 150 Mar-23 150 Assy 3 Feb-23 100 Feb-23 100 Assy 4 Mar-23 140 Feb-23 140 Assy 5 Mar-23 130 Apr-23 130 Assy 6 Apr-23 90 TBD Assy 7 May-23 80 TBD Assy 8 Jun-23 150 TBD Assy 9 Jun-23 130 TBD Assy 10 Jun-23 125 TBD

See the above table. Now I want to plot cumulative line graph for planned vs actual.

Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors