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

3 Replies

  • 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