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 September for a specific client Abbreviation, then count those number of times there is a date for September.

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

     

22 Replies

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

       

      COMPANYCODEDEVELOPMENTCODERELEASE_DATEJIONUMBERUNUSEDCOSTFLAGSALESRELEASEDATECONTRACT_DATERATIFIED_DATE
      1AGWednesday, November 2, 2016  X Friday, January 27, 2017Friday, January 27, 2017
      1AGWednesday, May 31, 2017  X Tuesday, April 17, 2018Tuesday, April 17, 2018
      1AGWednesday, November 2, 2016  Y Sunday, September 15, 2019Sunday, September 15, 2019
      1AGMonday, May 22, 2017  Y Sunday, September 1, 2019Sunday, September 1, 2019
      1AGThursday, June 8, 2017  X Thursday, February 21, 2019Thursday, February 21, 2019
      1AGWednesday, May 31, 2017  X Thursday, February 22, 2018Thursday, February 22, 2018
      1AG   Y   
      1AG   Y   
      1AGWednesday, May 29, 2019  Y   
      1AG   Y   
      1AGMonday, February 26, 2018  X Monday, December 18, 2017Monday, December 18, 2017
      1AGMonday, April 17, 2017  X Thursday, March 31, 2016Thursday, March 31, 2016
      1AG   Y   
      1AGTuesday, March 21, 2017  Y   
      1AG   Y   
      1AG   Y   
      1AGWednesday, November 2, 2016  X Friday, November 4, 2016Friday, November 4, 2016
      1AGWednesday, May 3, 2017  X Friday, April 7, 2017Friday, April 7, 2017
      1AGWednesday, November 2, 2016  X Wednesday, March 30, 2016Monday, November 28, 2016
      1AGWednesday, November 2, 2016  X Sunday, January 22, 2017Sunday, January 22, 2017
      1AGWednesday, November 2, 2016  X Thursday, October 27, 2016Tuesday, November 29, 2016
      1AG   Y   
      • Kornholio's avatar
        Kornholio
        Icon for Helper III rankHelper III
        6 years ago

        So using the Development Code, count the number of times in September of 2019 that there was a date