Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Thanks a lot
It works great.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |