Dynamic days measure

[ooctaviano]

Hello

Is there dax formula that helps me to count the days between to dates but based on the a selection used on a slicer (dates), or the number of days in a month (selected in a slicer).

Kind regards

Omar Octaviano

[camargos88 · Accepted solution]

@ooctaviano ,

Try this measure:

_NumDays = 
VAR _minDate = MINX('Calendar', 'Calendar'[Date])
VAR _maxDate = MAXX('Calendar', 'Calendar'[Date])
return DATEDIFF(_minDate, _maxDate, DAY) + 1

See the attached file for more info.

[ooctaviano]

Thanks a lot

It works great.