Forum Discussion

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
8 years ago
Solved

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

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi dsabsi,

     

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

     

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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
8 years ago

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

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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.