Forum Discussion
abhi_kothekar
3 years agoFrequent 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 m...
- Anonymous3 years ago
Hi abhi_kothekar ,
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= ADDCOLUMNS( _table1,"Cumulative Plann", IF( [Cumulative1]=BLANK(),BLANK(), SUMX(FILTER(_table1,[Year]=[Year]&&[Month]<=EARLIER([Month])),[Cumulative1]))) return ADDCOLUMNS( _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
lbendlin
Super User
3 years agoPlease provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?