Datediff count using a slicer - unless it'd up-to todays date?

[FlankyPank2___]

Hi,

Sorry I'm useless.  I cant figure this out.

I have this measure which works well but I don't wan't it to count up past todays date.  Is it possible to amend this dax to do that?

Slicer Day Count 24-25 = var _max = maxx(ALLSELECTED('Date24-25'),'Date24-25'[Date]) var _min = minx(ALLSELECTED('Date24-25'),'Date24-25'[Date]) return datediff(_min,_max,day)+1

Thank you.

[Anonymous · Accepted solution]

Hi @FlankyPank2___ ,

I create a table as you mentioned.

Then I create a measure and here is the DAX code.

Measure = 
VAR _max =
    MIN ( TODAY (), MAXX ( ALLSELECTED ( 'Date24-25' ), 'Date24-25'[Date] ) )
VAR _min =
    MINX ( ALLSELECTED ( 'Date24-25' ), 'Date24-25'[Date] )
RETURN
    DATEDIFF ( _min, _max, DAY ) + 1

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FlankyPank2___]

I Can' thank you enough - That works wonderfully

[Joe_Barry]

Hi @FlankyPank2___ 

Why not try TODAY() instead of Max Date?

Joe

[FlankyPank2___]

Hi,  thanks for replying.

I've tried adding in today() in various places but tbh I dont understand the majority of dax yet & i'm just winging it.

i'll get there.

Thank you