common keyword vs new keyword

[Arvind_123]

Hi Team,

I have column like month, keyword name from this I want to fetch common keyword arrival and new keyword arrival as compare to previous month.

how to do this in power bi dax.

Thanks,

Arvind

[vanessafvg]

can you provide some sample data with an example of what you are expecting?

[Arvind_123]

Hi @vanessafvg ,

Please find the table.

Input		Output
Month	keyword		Month	Keyword	Common/New
Oct	A		Nov	A	Common
Oct	B		Nov	B	Common
Oct	C		Nov	C	Common
Oct	D		Nov	D	Common
Oct	E		Nov	X	New
Oct	F		Nov	Y	New
Oct	G
Nov	A
Nov	B
Nov	C
Nov	D
Nov	X
Nov	Y

Thanks,

Arvind

[vanessafvg · Accepted solution]

there could be a few ways of doing this, depending on the nuances that i am not aware of, however this should give you a flavour of how you can do it.

here is the code and i attach the pbix. let me know if you have any questions

just to note that i converted your month value to a date value

Keyword Type =

VAR dte = //get last months date

    DATEADD(LASTDATE ( 'month_keyword'[Date] ),-1,MONTH)

VAR keywords = //select current keyword against current date

    SELECTEDVALUE ( month_keyword[Keyword] )

VAR match = //see if keyword existed previous month, if so count 1

    CALCULATE (

        COUNTROWS ( month_keyword ),

        month_keyword[Date] = dte

            && month_keyword[Keyword] = keywords

    )

RETURN //if no rows then new else common

    IF ( match > 0, "common", "new" )

[vanessafvg]

are you only ever only looking at the previous month, or are you looking at all previous months?

[Arvind_123]

Hi @vanessafvg ,

I am looking for previous month and current month comparison.

Thanks,

Arvind