Previous Month should display 0 if there is no change

[mudegowdrp]

New count should zero for Jan month as there is no new items added.

Please see dataset and help me

I am getting output like this

Here is my dataset and Expected result

Measure looks like this.

NewApp = COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( Sheet1[App Name] ),
            "PreviousApps", CALCULATE (
                COUNTROWS ( Sheet1 ),
                FILTER (
                    ALL ( 'Sheet1'[Date].[Date] ),
                    'Sheet1'[Date].[Date] < MIN ( 'Sheet1'[Date].[Date] )
                )
            )
        ),
     
    [PreviousApps] = 0
))

Please help.

[nickchobotar · Accepted solution]

@mudegowdrp

Give this one a try.

NewAppsCol =  
VAR Test =
    COUNTROWS (
        FILTER (
            Table1,
            Table1[Date] <= EARLIER ( Table1[Date] )
                && Table1[AppName] = EARLIER ( Table1[AppName] )
       )
    )
RETURN
IF(Table1[Month] = "January", BLANK(),  IF ( Test > 1, BLANK (), Test ))


NewAppsCount = COUNT(Table1[NewAppsCol])

[mudegowdrp]

@nickchobotar it works. Thank you so much 🙂

[Greg_Deckler]

Can you explain in words what defines the criteria for a "New App"? I can't really understand the criteria you are going for from your measure formula.

[mudegowdrp]

@Greg_Deckler Thank you for responding.

I need to buid a dashboard on Application Inventory dataset.

It has ID, Application Name and Date attribute.

What I need to show is new applications added month to month.

[mudegowdrp]

@Greg_Deckler Please see for more details. I need to show new Applications added month to month.

Ex: January Month has 3 Applications: a, b, c

     February has 2 new Applications: a,b,c,d,e

     March has 1 new Applications: a,b,c,d,e,f

     April has 0 new Applications: a,b,c,d,e,f

So my result table in power bi should give output as

Month           Application_Count           New_Application_Count

Jan                   3                                       0

Feb                  5                                       2

Jan                   6                                       1

Jan                   6                                       0

And When I click on February row

It should show

New Applications in February

d

e

[Greg_Deckler]

I created a month table like:

Month, Num

Jan,1

Feb,2

Mar,3

Apr,4

My Apps table also included month short names, you could do this with a FORMAT or just get rid of the text-based month names and go with numeric using MONTH function. Related these two tables, then you can create calculated columns in Months table like so:

TotalApps = CALCULATE(COUNT(Apps[App]),FILTER(Apps,MONTH(Apps[Date])<=[Num]))

NewApps = VAR new = CALCULATE(COUNT(Apps[App]),FILTER(Apps,MONTH(Apps[Date])=[Num]))
RETURN IF(ISBLANK(new),0,new)

[mudegowdrp]

@Greg_Deckler you are saying that Date Attribute in Apps table should be month number?

[mudegowdrp]

@nickchobotar by any chance did you delete your solution which you provided here?