Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter table for selected Date but next year

Hello all

 

I have a report, looking like that:

The tables contain the same columns. The right one is not filtered by the two slicers. 

My goal is, when i select a [From] and a [Till] date in the slicer, the right table should filter by these dates but from next year. so in this example, 01.06.2019 till 31.05.2020

 

I tried it with measures to get the selected date, make this date the same but next year (even struggeling with leap years) and using an if that looks the [From] date with the [From_nextYear] but as this is built from the [From] field its in a loop i think...

 

Side note, [From] Date is always the first, [Till] Date always the last day of each month.

 

Any ideas?

Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    Anonymous  i do not think you can use selected value in this context, you can grab the value from selected value but as soon as you use it to filter another table, it seems to set the filter context to blank.  I dont think ive ever tried as hard to solve an issue because it has me baffled but i think its the filter context of selected value is not propagated outside of the table it belongs to.

     

     

9 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous 

     

    not quite sure what you asking,

    where do you want the measure?  are your slicers correct

     

    so you want to create a measure in the right column?  can you share your file or code?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Would like to only create an example file unless i really have to..

      What i was talking about my measures and tries, never mind, was only to show my thoughts on this.

       

      Yes, i want a measure for my right table to filter the dates according to the slicers in the left half.

      Selected [From] in slicer: 01.06.2018

      Selected [Till] in slicer: 31.05.2019

       

      Right table should only show entries where [From] = 01.06.2019 and [Till] = 31.05.2020

       

      Does this help a little?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi vanessafvg 

        i now tried another way. Duplicated my orderlines table. in the duplicate i make an the following if:

        FromIsNextPeriod = IF('ssbi Orderlines_dupe'[From].[Date] = [SelectedFrom_NextYear];"true";"false")

        Weired thing is, in the table the two values are the same, but the if says "false":

         

        How is this possible? Both have date format, tables are not connected to each other.