Display last 4 weeks full data from todays date ignore Uncomplete week data

[avulasandeep]

Hi Everyone,

i need one help,

here i am showing the first-week date and last week date with respective formulas from below pics and

my question is I need to show the only last 4 completed weeks data from today date in the report

but it is showing the incomplete week data also . i no need that .

Can any one know about this  i need last 4 complete  weeks  data based on first week date and last week date.

below is the pics of my report.

the first week is Sunday 
last week is Saturday

Here is the first day of the week formula i used  :

Here is the first day of the week formula i used  :
 

Here is the Report i created   :

 Here is the requirement  i need below :

here i want previous 4-week complete data ignore present week bcos it is incomplete.

help me if any one know this.

Thanks 

Sandeep kumar

9441181581

avulasandeep19@gmail.com 

[quentin_vigne · Accepted solution]

@avulasandeep

Here is a detailed example :

 

Put that filter on your visual or your page and it should do the job

[avulasandeep]

hi quentin_vigne,

i took Monday as Week Start Day and Sunday as week End day, but when it was Saturday or Sunday it is showing only last 3 weeks data only, the 4th-week data is Missing. 

Can you please tell why it happening??

Date column using the formula : "First week date = (Sales Table[date]+7-weekday(Sales Table[date]),1)"

i am keeping this column in visual level filter and using as the relative date of last 4 calender weeks  but it is displaying 3 weeks data when week is "Saturday or Sunday " and by Monday it showing all the 4 Weeks.

Waiting for reply 

Thanks 

sandeep

[avulasandeep]

A Very Big Thanks (Kudos) to  " quentin_vigne "

Its Working fine 

Thanks 

Sandeep

[quentin_vigne]

Hi @avulasandeep

You can use the relative date filtering as shown below

You can type 4 then weeks to filter your datas

For what you are asking you must use the calendar week options, it will only display the entire weeks 

Quentin