Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Problem finding new students....

  • 1.  Problem finding new students....

    Silver Contributor
    Posted Nov 02, 2019 05:09 AM
    Hello,
    I have a problem that I just solve but the solution I just found me to create 2 tables because I use the function EXCEPT so it does not suit me. I am exposing you to the subject.
    I have a new employee file that is updated every week in a "Date" field (7/10 / 2019,14 / 10 / 2019,21 / 10 / 2019,30 / 10/2019) and a field " arriving. " I have to find newcomers on every week if there are any. If I use a visual matrix I see newcomers. I would like to find the function that allows me to extract.
    I think that must be possible? but on my side I do not have the logic .... thank you for your help.
    I joined the PBIX file


    ------------------------------
    pascal millet
    0493955869
    ------------------------------

    Attachment(s)

    pbix
    TestArrivants.pbix   93K 1 version
    Conference-PBI_200x200


  • 2.  RE: Problem finding new students....

    Top Contributor
    Posted Nov 02, 2019 01:18 PM
    Hi Pascal,

    Please upload the Excel file you used as the data source.
    I cannot see or interact with your data because the Excel workbook is on your local computer.


    ------------------------------
    Audrey Abbey
    SR. BI Developer/Analyst
    LeapFrogBI
    Portland OR
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Problem finding new students....

    Silver Contributor
    Posted Nov 02, 2019 01:42 PM
      |   view attached
    Hi Audrey,
    sorry i was in town ..... here is the file. Thanking you.


    ------------------------------
    pascal millet
    0493955869
    ------------------------------

    Attachment(s)

    xlsx
    EffectifBasePoweBi.xlsx   1.38MB 1 version
    Conference-PBI_200x200


  • 4.  RE: Problem finding new students....

    Top Contributor
    Posted Nov 06, 2019 10:46 AM
      |   view attached
    Hi Pascal,

    Sorry about the delay. I got really busy at work.

    I have attached your file with two possible solutions.
    One uses the Query Editor to group the data set and get the min and max dates.
    One uses a DAX calculated column to do basically the same thing.

    One problem is that they produce slightly different numbers.
    I traced that out to an issue in your data, where one person has the last name spelled differently.
    This will make the Query Editor method incorrect, as it uses the last name as part of the group by.
    The DAX calculation uses the Code_Apprenant column to do the grouping.

    Let me know if you have any questions.



    ------------------------------
    Audrey Abbey
    SR. BI Developer/Analyst
    LeapFrogBI
    Portland OR
    ------------------------------

    Attachment(s)

    Conference-PBI_200x200


  • 5.  RE: Problem finding new students....

    Silver Contributor
    Posted 30 days ago
    hello Audrey,
    Thanks for your intervention.
    Is Monaco a special case? Where is this kind of information? Of course I will never have thought of that and yet I have looked at the documentation on the subject.
    
    Thank you again and have a nice week end


    ------------------------------
    pascal millet
    0493955869
    ------------------------------

    Conference-PBI_200x200


  • 6.  RE: Problem finding new students....

    Top Contributor
    Posted 30 days ago
    I think Monaco is a special case because it is considered an independent city-state, rather than a city within a country.
    I believe the Vatican works the same way. You have to but in Vatican City.

    If you go to Google Maps or Bing Maps and zoom in far enough, you can see the label Monaco Ville or Monaco City.
    That is how I figured out what was wrong.
    Monaco is considered the country. Monaco City is considered the city.

    ------------------------------
    Audrey Abbey
    SR. BI Developer/Analyst
    LeapFrogBI
    Portland OR
    ------------------------------

    Conference-PBI_200x200


  • 7.  RE: Problem finding new students....

    Silver Contributor
    Posted 30 days ago
    Thank you for these explanations. If I have a problem on a similar case I will see on Bing or Google.
    Thank you for your good answers :-)


    ------------------------------
    pascal millet
    0493955869
    ------------------------------

    Conference-PBI_200x200