Forum Discussion

akos_skutovics's avatar
akos_skutovics
Icon for Helper I rankHelper I
1 year ago

DAX Date Range Summary

Does anyone have effective DAX code for summarizing a selected date range in an easily readable format for both continuous and non-continuous periods? I typically use a slicer with these columns: ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

What if November 2023, December 2023 and January 2024 are selected?

  • akos_skutovics's avatar
    akos_skutovics
    Icon for Helper I rankHelper I
    1 year ago

    I would expect Nov 2023 - Jan 2024

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Sounds like a nice project. There will be lots of pitfalls (for example when someone selects 2024 Q1 and September 2023) but it will be fun to explore all the intricacies of ISINSCOPE.  Good luck.

       

      Note: Is that something that your users asked for?  What is the business value? Why not use the filter icons?

      • akos_skutovics's avatar
        akos_skutovics
        Icon for Helper I rankHelper I
        1 year ago

        When 2024 Q1 and September 2023 are selected, I would probably default back to month level:
        Sep 2023, Jan-Mar 2024.

        The use case is to display a summary of what is shown on a page in combination with other slicers and description of the main visuals, for easy understandability for people who does not have a lot of experience with consuming Power BI content.

         

        What would be the most optimal way to tackle this?