Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Arvind_123
Helper I
Helper I

New keyword vs Common Keyword

Hi Team,

I have raise this query in power bi community but not got answer.
can you please help me with this?

I have table BT3 Keyword (2) that have column name like Month Id, Management Group, Keyword, Source Name and from this I want to check New keyword count in every current month.. Suppose if Keyword is present in the current month and has no value in any previous month then make it as "New" and If current month keyword present in any of previous month keyword make it as common.

so I have made dax for it .. it is working fine with overall new distictcount when no management group selelcted but when I select any of management group it is giving me lesser value as compare to Excel. Is it beacuse of the keyword is present for other mangement group too ? that is the why my dax not working properly ?

I want every keyword should be count for every management group level.

can you please help me to solve this query?

I have used this dax query to find out the New count in power bi desktop:

step 1: I have created a calculated column as to find New vs Common:

KeywordStatus = IF ( NOT ( COUNTROWS ( FILTER ( ALL('BT3 Keyword (2)'), 'BT3 Keyword (2)'[Keyword] = EARLIER('BT3 Keyword (2)'[Keyword]) && 'BT3 Keyword (2)'[Month Id] < EARLIER('BT3 Keyword (2)'[Month Id]) ) ) ), "New", "Common" ) ​

 

step 2:
I have created a measure to find out Distictcountof New keyword as:
NewC = CALCULATE( DISTINCTCOUNT('BT3 Keyword (2)'[Keyword]), FILTER( 'BT3 Keyword (2)', 'BT3 Keyword (2)'[KeywordStatus] = "New" ) )

 

Thanks,

Arvind

3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @Arvind_123 ,

Please consider providing a file without sensitive data and posting the expected output, it would be very helpful, thank you.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

 

Hi @v-cgao-msft ,

 

This is the image view.

 

Sippose this is the input table that I have:

InputInput

 

Output I need of New Keyword Distinct Count of all sourec where project I have select as A for filter.

 

OutputOutput

 

Note : New keyword means that the keyword is present in current month but not present in any previous month.

 

Thanks,

Arvind

Hi @v-cgao-msft ,

Thanks for reply!
This is the input table.

Month IdYear MonthProjectKeywordSource NameRevenue
12202312Amedical asst columbia ceAditya9
12202312Atop ai stocks to invest inAayansh8
12202312Burgent jobs hiring nowAnand8
12202312Bupcoming stock-split stocks to buylallan4
12202312Ccauses of guillain barré syndromeAditya9
11202312CBig and Tall Mens Clothing OnlineAayansh7
11202312Cmedical asst columbia ceAnand3
11202312Dtop ai stocks to invest inlallan9
11202312Dupcoming stock-split stocks to buyAditya6
11202312Eis 5g internet available in my areaAayansh1
11202312Etop ai stocks to invest inAnand4
10202312Fjefferson standard life insurancelallan8
10202312Fmedical asst columbia ceAditya4
10202312Bwho does 40 year mortgagesAayansh8
10202312Bdoctors who treat osteoarthritisAnand7
10202312Btop ai stocks to invest inlallan5
9202312Aupcoming stock-split stocks to buyAditya9
9202312Acheapest way to lay artificial grassAayansh6
9202312Aincome based senior living in cityAnand10
9202312Dupcoming stock-split stocks to buylallan10
9202312Ctop ai stocks to invest inAyansh7


output I needed is New Keyword distinct count source wise :
Here suppose  I have selected on slicer -- project as A then what is the new keyword count of that particular project A on source level looks like this based on above Input table :

 ProjectA  
     
 Month Id 
Source1211109
Aditya1001
Aayansh1001
Anand0001
lallan0000
Ayansh0000
Total2003

 

Note : New keyword means that the keyword is present in current month but not present in any previous month.


Please let me know if you need any further details.

Thanks ,
Arvind

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.