Table value as on selected month in slicers

[NadeemAhamed]

Dear Community..

Good Day..!

I have one table with columns such as month,previous year,plan,plan cumulative,actual & actual cumulative.

Iam going to have one slicer for month.

Is it possible to bring the table values as on selected month and actual cumulative values should be based on actual column. 

Thank you for your adavance. 

[amitchandak]

@NadeemAhamed , You can get cumulative sales using these measure with help from a date table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

[NadeemAhamed]

Dear @amitchandak 

Thank you for your valuable time to read and response.

Sorry to say this, iam not able to relate this measures to my requirement and table. 

My table say financial data from April - March

If user has selected May month means the Graphs should show the data from April- May.  

1. Assume i have selected Aug month from the silcers. 

I need to show the table data in graphs as on selected month.

2. Assume i have selected Sep month from the silcers. 

I need to show the table data in graphs as on selected month.

Prevosly i have added another column for monthly but if i have added then the table rows become 12*12=144 rows 

but that table structure is not accepting.