Forum Discussion

Mayugi's avatar
Mayugi
Regular Visitor
4 years ago
Solved

Relative slicers

can I have relative slicer with cumulative month increment ex [Jan 2022 - Feb 2022] then [Jan 2022 Feb 202] and so forth?
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Mayugi ,

    Please create a measure as below and check whether it can get your expected result:

    Measure =
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] >= DATE ( 2022, 1, 1 )
                && 'Table'[Date] <= _seldate
        )
    )

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

amitchandak's avatar
amitchandak
Super User
4 years ago

Mayugi , You can relative date slicer for last 2 months

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • Mayugi's avatar
    Mayugi
    Regular Visitor
    4 years ago

    Trying to create a Month - Year filter, that can be grouped by adding an additional month on the next segment. Example, date column with he following ranges. Jan 2022 - Feb 2022

                                                                                                  Jan 2022 - Mar 2022

                                                                                                  Jan 2022 - Apr 2022

                                                                                Up untill     Jan 2022 - May 2022  as this is the current month, and  roll over to next months as we get there, up untill the end of the year. Is it possible to create  such a filter? Thanks.

     

                                                

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Mayugi ,

      Please create a measure as below and check whether it can get your expected result:

      Measure =
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] >= DATE ( 2022, 1, 1 )
                && 'Table'[Date] <= _seldate
        )
    )

      If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

      How to upload PBI in Community

      Best Regards