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
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?