Forum Discussion

Kornholio's avatar
Kornholio
Icon for Helper III rankHelper III
6 years ago
Solved

Count Non Blank Dates for current month

I have a table that has Ratified Dates, so I want to count the number of Ratified Dates that have a date in them and by current month, or by specfic Month. For example, there are 3 Ratified dates in ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    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.
    Nathaniel


    Ratified 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

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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.
Nathaniel







Current 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_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

PBIX