How do you show your data except for the last 6 weeks?

[dsabsi]

Hello everyone, 

I need your help with my Power BI dashboard. 

I have plotted a bunch of data regarding the revenues per customer and I have added year + week filters (DIM_DATE). 

I want to add a visual level filter in which I show all the data except for the last 6 weeks. 

Can anyone please help me with this? 

Thank you very much!!! Of course all of you will get thumbs up 😉

Here a printscreen of my DIM_DATE:

Cheers, 

DSabsi

[Greg_Deckler]

You probably want to add a calculated column that calculates the week differential from the current week. You can use WEEKNUM and TODAY functions for this in DAX. Then you could add this column to your visual filter area and restrict it to the values you want, >5 or >6 differential.

[dsabsi]

@Greg_Deckler, thanks for your swift reply. 

I tried to use your calculated solution but it didn't work for me...it shows as date 10-9-2017 which is 6 weeks ago. 

the formula: smoupre = today()-(weeknum(today();1)-6) 

but I want to have all the data except for 6 weeks ago... could you please be so kind to write this formula? 

Cheers, 

DSabsi

[v-jiascu-msft · Accepted solution]

Hi @dsabsi,

How about this? All the [FilterColumn] = 1 is the data you want.

FilterColumn =
IF ( [Date] <= TODAY () - 42, 1, 0 )

Best Regards!

Dale

[Greg_Deckler]

Assuming you have a Date column:

WeekNum Diff = WEEKNUM(TODAY()) - WEEKNUM([Date].[Date])

You could then filter this to be greater than 5 or 6. Might have some Year issues to worry about (a week in 2016 is the same weeknum as a week in 2017) but this is the general idea.