Forum Discussion

ihatesand's avatar
ihatesand
New Member
6 years ago
Solved

Ignore blank rows in Date Filter

I have a report that requires date filters.  The filter needs to be conditional, meaning if rows have certain values they should always be present no matter what is in the date filter.  I thought I h...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi ihatesand ,

     

    We can try to create a special calendar table as slicer to meet your requirement:

     

    SpecialCalendarTable = UNION(ADDCOLUMNS(CALENDARAUTO(),"LinkedDate",BLANK()),ADDCOLUMNS(CALENDARAUTO(),"LinkedDate",[Date]))

     

     

     


    If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？


    By the way, PBIX file as attached.


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ihatesand ,

 

We can try to create a special calendar table as slicer to meet your requirement:

 

SpecialCalendarTable = UNION(ADDCOLUMNS(CALENDARAUTO(),"LinkedDate",BLANK()),ADDCOLUMNS(CALENDARAUTO(),"LinkedDate",[Date]))

 

 

 


If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？


By the way, PBIX file as attached.


Best regards,

 

ihatesand's avatar
ihatesand
New Member
6 years ago

Hi v-lid-msft ,

 

This appears to solve my issue thank you.  The file you dropped helped tremendously, however Im not sure where you created the SpecialCalenderTable, it does not appear in your sources.

 

Thanks