Card with Date Range - Last Date Issues

[jessimica1018]

Hey all!!!

I have a measure to pull the date range of the filters, well it should.... 
The LastDate is pulling 12/31/2022 instead of the date on the filter.

Date Range = FIRSTDATE('Fuze Calls'[Calls Started Date]) &" - "& LASTDATE('Fuze Calls'[Calls Started Date].[Date])

Any ideas on how to get this to work???

[jessimica1018]

I did end up getting this to work - I did a date table and then built the exact same messure I built the first time and it worked!! .....No clue why..... but it's all good now!

[TheoC · Accepted solution]

Hi @jessimica1018 

You may need to wrap your FIRSTDATE and LASTDATE in a CALCULATE ( ..... , ALLSELECTED ( 'Table'[Calls Started Date] ) )... if you do this, this should hopefully reflect the filtered dates.

Measure = 

CALCULATE ( 
   FIRSTDATE ( 
       'Fuze Calls'[Calls Started Date] ) , 
           ALLSELECTED ( 'Fuze Calls'[Calls Started Date] ) 
            ) &" - "& 
CALCULATE ( 
   LASTDATE ( 
       'Fuze Calls'[Calls Started Date] ) , 
            ALLSELECTED ( 'Fuze Calls'[Calls Started Date] ) 
          )

I haven't tested the syntax but hopefully it works!

Let me know how it goes.

Theo

[jessimica1018]

Sadly no luck, it is a nice measure though!

I'll keep working at it and playing around with formulas to see if anything sticks.

Thank you!

[TheoC]

Hi @jessimica1018 sorry it didn't work for you. It's weird as I tested the syntax and all looked good. Glad it got resolved though! 🙂