I would like to get only one max value for each student ID.For example, a company needs to examine each person's attendance and identify the arrival time for being late monthly, but for the clarity of the report, it is required that if there is a duplication of the arrival time for being late, only one is identified.
Another example is a sales company that needs to mark the maximum monthly sales of each salesperson on the sales sheet and display the data during meetings. At this time, the maximum sales are duplicated, and if they are all marked, it will affect the beauty of the whole report, so only one of the duplicated maximum values should be randomly marked.
Python and Power BI There are many tutorials on Python scripts, but here I would like to offer some insights on using Python combined with Power BI. The official document already have a tutorial on how to install Python and some basic uses. We can either install python Anaconda3 pack or download python and install pandas and matplotlib packages with commands. Some commonly used packages are configured in Anaconda 3, it is not necessary to install pandas and matplotlib separately if Anaconda 3 is already installed.
In Power BI, when we want to process complex and unordered data, adding many steps using power query may not get the desired results. As we know, power query cannot use regular expressions. If we call Python script and use regular expressions to process the data this time, it will become simple.