Forum Discussion

B_Real's avatar
B_Real
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

select which filter to use

I have a date dimension that contains the date an event is due to fall on. I have created one additional column to flag if the date occurs within 7 days of today's date, and a second column to flag i...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    B_Real

     

    According to your description, it seems you want to achieve a last X period slicer to filter dates. In this scenario, you need to create a calculated table for each period, and union those calculated tables into a "DatePeriod" table. Then build the relationship to date table for filtering. For more details, please see a blog below:

     

    POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

     

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

B_Real

 

According to your description, it seems you want to achieve a last X period slicer to filter dates. In this scenario, you need to create a calculated table for each period, and union those calculated tables into a "DatePeriod" table. Then build the relationship to date table for filtering. For more details, please see a blog below:

 

POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

 

Regards,

 

B_Real's avatar
B_Real
Icon for Advocate IV rankAdvocate IV
9 years ago

Two good answers there! I've chosen v-sihou-msft's as the accepted solution because I found that post easier to implement, but I believe both will work. 

 

Thanks for the responses guys!