how to show data column with different date in one table

[shahidalaila23]

Hi, 

I'm sorry for the confusing subject, I don't know how to say it short. 

I have a set of table with measure, when I put all data in one table usually it will follow the cummulative date of all the data, for now if I want to show only data of first week (from 1 until 7) I put date on filter. My question is, is there a possible way to have different date in one table? 

my table is as below : 

qtyADS is an average measure for qty total. For the table is now filtered for 1 until 7 (first week) and I have data until 30th of the month. 

I'm really new in using power Bi and still have problem using DAX, so I really appreciate your help. 

[amitchandak]

@shahidalaila23 , You can cumulative like

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

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

[shahidalaila23]

but this will return the total for selected date, and how about if I have one column that show first week total (1 until 7) and other column that show second and third week, (6 until 14) , so I will have two or three column that show qtyADS for first week, second week, third week and final week of the month.