Selected Week from Next 4 week value calculation

Question

I have table name called Invenoty sheet . this table look like . i want filter it only Demand Attribute value . if Demand attribute value if date 15 March&nbsp; 2021 select from that date to Next week&nbsp; value&nbsp; Need to get it for 15 March 2021.&nbsp;I am Used below Measure&nbsp;Mesaure&nbsp; = CALCULATE(sum(Append1[Value]),FILTER(Append1,Append1[Attributes]="Demand"),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),1,MONTH))&nbsp;&nbsp;&nbsp;( 4&nbsp; week Consider as 1 week )&nbsp;INPUT:&nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ATTRIBUTE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;15 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4515 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2522 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5522 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3529 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6529 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8505 April&nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4505 April&nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8512 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9512 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6519 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4519 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3526 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4526 April&nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 65&nbsp;&nbsp;Expected Output :&nbsp;&nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ATTRIBUTE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Selected week from Next 4 week15 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp; &nbsp; 15+25+35+4522 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;170&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp; &nbsp;25+35+45+5529 March 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 35&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;190&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt;&nbsp; 35+45+55+6505 April&nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 210&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt;45+55+65+45--------------------31 December 2022&nbsp; &nbsp;Demand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;88&nbsp;Looking for support .. thanks in advance .,

v-yadongf-msft · Accepted Answer

Hi Anonymous&nbsp;,
&nbsp;
1.Please create a new table like below using following DAX:
Table = FILTER('Append1','Append1'[ATTRIBUTE]="Demand")

&nbsp;
2.Create a measure called Selected week from Next 4 week:
Selected week from Next 4 week = SUMX(
    DATESINPERIOD('Table'[DATE],MIN('Table'[DATE]),28,DAY),
    CALCULATE(SUM('Table'[VALUE]))
)
&nbsp;
3.In report page, please create a table visual, then you can see the total data for the last four weeks.
210 = 45+55+65+45
260 = 55+65+45+95
250 = 65+45+95+45
……

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

Forum Discussion

Selected Week from Next 4 week value calculation

2 Replies

Related content

Quarter calculation upto selected month

DAX for calculating retroactive values

Selected-Filtered value calculation

Calculated column from selected value

Calculated table column values changes on slicer selection