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

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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