Display a range of dates

Chapin4u

Create a Measure using either one of the Measures below they should give you some ideas how to tailor to your setup!

The second Measure allows you to use a custom Year-Mo column which is not formatted as Date.

You can modify these many other ways :smileyhappy:

In fact you can also use in conjunction with the FORMAT function!

Look at the Picture below to see the results...

Which way you decide to go will depend on how you aggregate your data.

Do you need to see the specific Dates or is Months only okay

Hope this helps! :smileyhappy:

Report FIRST/LASTDATE = FIRSTDATE('Calendar'[Date]) &" - "& LASTDATE('Calendar'[Date])

Report FIRSTNON/LASTNON 2 = 
IF (
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ) = LASTNONBLANK ( 'Calendar'[Year-Mo], 1 ),
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ),
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ) & " ~ " & LASTNONBLANK ( 'Calendar'[Year-Mo], 1 )
)

Report Period FORMAT = FORMAT(FIRSTDATE('Calendar'[Date]), "MMM yyyy") & " - " & FORMAT(LASTDATE('Calendar'[Date]), "MMM yyyy")