Forum Discussion

Arvind_123's avatar
Arvind_123
Icon for Helper I rankHelper I
2 years ago

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,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Arvind_123's avatar
    Arvind_123
    Icon for Helper I rankHelper I
    2 years ago

    Hi Anonymous ,

    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

  • Arvind_123's avatar
    Arvind_123
    Icon for Helper I rankHelper I
    2 years ago

     

    Hi Anonymous ,

     

    This is the image view.

     

    Sippose this is the input table that I have:

    Input

     

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

     

    Output

     

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

     

    Thanks,

    Arvind