cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

 
Super User IV
Super User IV

Re: Count Non Blank Dates for current month

You save your pbix on one drive, or drop box. Then copy the link and paste it using the hypelink symbol between the smiley face and the camera.  Do you want me to limit it to the one company? I need to go off line in about 15 min.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

Here is at least a ouput with all codes and dates. Need to show all Development Codes and there total dates inputted if there is one for he current month. Note the last month in the data is September, but each month it will start fresh, so  when the data is inputted on November 1st, then it will show a count of ratified dates for November onwards
.


DEVELOPMENTCODERATIFIED_DATE

AG9/15/2019
AG9/1/2019
BH7/10/2019
BH7/31/2019
BH9/11/2019
BM6/22/2019
BM6/2/2019
BM5/16/2019
BM9/26/2019
BV8/2/2019
BV6/29/2019
BV8/13/2019
BV7/14/2019
BV6/30/2019
CC8/17/2019
CC9/24/2019
CP9/25/2019
CP8/18/2019
CP9/8/2019
CP9/30/2019
CP9/9/2019
CP9/22/2019
CT5/31/2019
CT5/11/2019
EG9/15/2019
EG5/3/2019
EG5/1/2019
EG9/29/2019
EG5/30/2019
EG9/28/2019
EG7/26/2019
EG9/23/2019
EG9/28/2019
EG8/11/2019
EP9/19/2019
EP5/31/2019
EP6/25/2019
EP5/13/2019
FC6/5/2019
FC9/20/2019
FC7/6/2019
FF9/3/2019
FF8/9/2019
FH7/31/2019
FH8/9/2019
FX5/1/2019
FX8/4/2019
FX6/23/2019
FX7/15/2019
HG5/5/2019
HR5/5/2019
HR9/20/2019
HR9/6/2019
HR5/5/2019
HR8/8/2019
HR8/11/2019
HR8/18/2019
HR8/11/2019
HR8/30/2019
LF8/25/2019
LF8/1/2019
LF9/29/2019
LF9/13/2019
LF9/6/2019
LF5/18/2019
LF9/24/2019
LF8/5/2019
LF6/30/2019
LF6/8/2019
LF8/4/2019
LF8/22/2019
LH8/3/2019
LL5/31/2019
LL7/27/2019
LL8/18/2019
LL6/9/2019
LL5/9/2019
LL9/30/2019
LL6/11/2019
LL6/22/2019
LP6/20/2019
MF8/10/2019
MF7/8/2019
NR6/21/2019
OE9/29/2019
OE9/21/2019
OE8/26/2019
OV5/30/2019
OV6/2/2019
OV6/27/2019
PR9/25/2019
PR9/1/2019
PR6/2/2019
PR7/16/2019
PR6/12/2019
PR7/30/2019
RG5/28/2019
SC8/16/2019
SC9/15/2019
SP5/4/2019
SP7/16/2019
SS8/11/2019
SS9/25/2019
SS7/13/2019
SS6/28/2019
SS6/21/2019
US8/29/2019
VR5/5/2019
VR9/28/2019
VR5/29/2019
VR6/9/2019
VR8/9/2019
VR8/1/2019
VR6/11/2019
VR6/17/2019
WH6/28/2019
Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

going to dropbox it now

 

Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

let me know if this worked for dropbox

 

Super User IV
Super User IV

Re: Count Non Blank Dates for current month

PBIX 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

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

Highlighted
Super User IV
Super User IV

Re: Count Non Blank Dates for current month

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

Rat date1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Kornholio Regular Visitor
Regular Visitor

Re: Count Non Blank Dates for current month

I think this will work thanks!

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors