How to find Countblank

[Anonymous]

Hi Seniors,

1. I need to find the blank count between data, from launched date

2. find max blank count between data from launched date

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description,I think you can create two measure to calculate the correct results.

Like this:

countblank =
COUNTBLANK ( Table1[number] )

max countblank =
VAR maxdate =
    MAXX ( ALL ( Table1 ), [date] )
VAR tableindeax =
    SUMMARIZE (
        FILTER ( ALLSELECTED ( Table1 ), [number] <> BLANK () ),
        Table1[date],
        Table1[number]
    )
VAR minxdate =
    MINX ( ALLSELECTED ( Table1 ), [date] )
VAR minxdateindex =
    MINX ( tableindeax, [date] )
VAR countfirst =
    DATEDIFF ( minxdate, minxdateindex, DAY )
VAR tab =
    ADDCOLUMNS (
        tableindeax,
        "New",
            VAR next =
                MINX ( FILTER ( tableindeax, [date] > EARLIER ( Table1[date] ) ), [date] )
            RETURN
                DATEDIFF ( [date], next, DAY ) - 1
    )
RETURN
    MAX ( MAXX ( tab, [New] ), countfirst )

Here is my sample .pbix file.Hope this helps.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Check if somthing like this can work

countrows(filter(table,isblank(table[column])))

[Anonymous]

HI,

im new

its in pivot table, explain clear little bit

thanks advance