Forum Discussion
Count Non Blank Dates for current month
- 6 years ago
Hi Kornholio
Try this: PBIX 10/20/2019
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielRatified Dates All = VAR _minDate = MIN ( Con2[RatifiedDates] ) VAR _maxDate = MAX ( Con2[RatifiedDates] ) VAR _calc = CALCULATE ( [Countrows2], FILTER ( ALLEXCEPT ( Con2, Con2[DevelopmentCode] ), Con2[RatifiedDates] >= _minDate && Con2[RatifiedDates] <= _maxDate ) ) RETURN _calc - 6 years ago
let me know if this worked for dropbox
Hi Kornholio ,
Have to go, here is my pbix. This responds to the slicer for the code, but not the date. I will come back to work on this - not this weekend.
Nathaniel
- Kornholio6 years ago
Helper III
HI, but if i look at "BM" Development Code I see there is only 1 Ratified Date for September, and on your PBX it shows 2 when it should show 1
- Nathaniel_C6 years ago
Community Champion
Hi Kornholio
Try this: PBIX 10/20/2019
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielRatified Dates All = VAR _minDate = MIN ( Con2[RatifiedDates] ) VAR _maxDate = MAX ( Con2[RatifiedDates] ) VAR _calc = CALCULATE ( [Countrows2], FILTER ( ALLEXCEPT ( Con2, Con2[DevelopmentCode] ), Con2[RatifiedDates] >= _minDate && Con2[RatifiedDates] <= _maxDate ) ) RETURN _calc - Kornholio6 years ago
Helper III
I think this will work thanks!
- Kornholio6 years ago
Helper III
Although, if i wanted to count current month, without having to choose the date filter, is that possible? So, I will have multple counts, each one will be for current month when opening the pbx. So, without having to choose any date filter, can we use your calc with the current month when opening the pbx?
- Nathaniel_C6 years ago
Community Champion
Hi Kornholio ,
I created two pages with the opening page having current month only. You could use a bookmark and a button if you wanted to get to second page or leave it as is. This will only work for the current month. It uses MONTH() and TODAY()
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielCurrent Month = var _currentMonth = Month(TODAY()) //takes today and selects the month, then applies it to the filter below VAR _calc = CALCULATE ( [Countrows2], FILTER ( ALLEXCEPT ( Con2, Con2[DevelopmentCode] ), Month(Con2[RatifiedDates]) = _currentMonth ) ) RETURN _calc - Nathaniel_C6 years ago
Community Champion