Velocity is Among the Top 8 Applications in the World / Hürriyet

Digital workplace platform Velocity, developed by PEAKUP, was chosen as one of the top 8 applications in the world. Velocity that has been chosen among thousands of apps uploaded to Microsoft Teams Store is the only Turkish application chosen. A lot of criteria from user-friendliness to prevalence were taken into consideration in the evaluation done by Microsoft Corp. that has its center in Seattle, USA.  

One of the top 8 application among all apps integrated to Microsoft Teams in global was evaluated as the strategic app that is believed to create highest amount of benefits, the app that has authority in digital marketing and the app that has the greatest potential to achieve global prevalence.

The notion of “digital workplace” that everybody is talking about gain more importance day by day in terms of the cloud services it contains, getting rid of geographical barriers with mobility and artificial intelligence apps and enabling access to information 24/7. Increasing employee commitment, making a difference in terms of working together and efficient, content/document management and facilitating work processes are among the most important goal of digital workplace applications. Velocity that has been developed in order to achieve these goals, claim to interaction between workers thanks to its collective structure and provide efficiency in the corporations.

The first step of adapting workers who are biased to working on digital platforms fast goes through intranet platforms. Intranet platform Velocity that digitalizes communication processes and makes the use as simple as possible, is one of the most helpful tools in the digitalization process of the companies.

Today Microsoft Teams that has 75 million daily single users and hosts 200 million meeting participants can be ingratiated with digital workplace platform Velocity. Velocity helps you to access a lot of information from your files to announcement, from LPPD to clarification texts and work procedures, from your documents to horoscope and service hours when used on Microsoft Teams. This way you can reach out to all your workers at the same time and at the same speed, and maintain your communication from one center.

Power BI – 2020 May Favorites

Hello dear reader! Here we are with the Power BI May updates. Compared to last month, this month’s updates are a bit more superficial. But of course there are some subjects that stand out as always. Let’s go and start analyzing the Power BI May updates right away.

1-Apply All Filters

There is a new button in the filter field. What does this mean? It means that now we have some options while applying filters:

  • The report can change immediately in accordance with the values we choose on the filter field.
  • You can add Apply button to filter headers from the filter field. In this step, you need to press this button after making filter choices.
  • You can ad an Apply button that would apply all the filters at once on the filter field. First you do your filters on all the headers and than press this button.

You can access this new option by going to File > Options and settings > Options > Query reduction.

 

The necessity of it is arguable but to tell the truth, I know that it has been asked if all these new filter pane skills didn’t exist. So it is for sure that their existence will make some happy. By the way with this update we say goodbye to the old filter pane, bye sweetie.

2- Buttons Now Support Fill Images

A feature very convenient for people who want to use different images and shapes instead of writing an expression only. You can put different images to default, on hover, on press, and disabled options. You can access the option where you can use a button for this on the Fill field.

 

buton image

3-Drop Shadow Support for Visuals

I think this is the most prominent one of Power BI May updates. I am really happy to to have shadow effect! It gives dimension to the chart field and thus is very useful. Before, we arranged these shadowed fields on PowerPoint and than brought it to the Power BI background. By the way, there a lot of options like angle, transparency under the Shadow title. Since we don’t have to do this anymore, a wide range of people will be satisfied. ❤

shadow, gölge

4- Conditional Page Navigation

Drill through option that was on preview is now generally available. Not only that, they also added conditional page navigation! This is a huge step. This means that you can show pages based on users! Let’s analyze its details all together. The main logic is that you need to enter the name of the page that will navigated by conditions into the DAX indicator.

5-Feature Table (Preview)

Actually it is one of the most interesting features of this month. Before, you had to download the Excel Analyzer extension to your computer that would run the Power BI data sets you were going to work on. After this step you had to download the data set connection. Now we can find the Power BI Dataset header on Excel. But for now, you have to have all the Office Insider programs to have this feature. I am waiting for the moment when we will be talking about it in detail when it is available for all users!

filtre butonu

6- New Data Source

  • Witivio

Witivio is an enterprise chatbot platform for employees with a deep integration in Microsoft 365 and the Power Platform. Without code, users can design and monitor chatbots for HR, IT HelpDesk and change management. Chatbot admins can track the usage and the performance of their chatbots to build advanced analytics.

You can find this connector in the Online services section of the Get data dialog.

  • Linkar Connector 

Linkar is a suite of components that facilitates efficient connectivity to MultiValue Databases. Linkar SERVER works with almost all MultiValue Database platforms centralizing connections and optimizing DBMS license usage. Client apps use Linkar CLIENT libraries to interact with the database through Linkar SERVER, with bindings for popular languages. This connector allows easy integration with MultiValue Databases through the Linkar platform.

You can find this connector in the Database section of the Get data dialog.

 Webtrends Connector

Webtrends Analytics is a Microsoft-preferred solution built from the ground up for the nuances of measuring performance of your website or SharePoint environments. This connector allows you to import your data into Power BI via our Data Extraction API (REST) with point and click ease. All reports on an individual profile are now available at once; no more limited report lists. The date range options have been expanded to allow standard report periods as well as custom date ranges. A customer account with Webtrends is required to use the connector.

You can find this connector in the Online services section of the Get data dialog.

Planview ProjectPlace connector

Get work done across projects and teams. Projectplace lets you plan, collaborate and track progress of all projects and assignments in an easy and user-friendly way.
This connector is supported by Planview as the preferred method of reporting on ProjectPlace moving forward. Existing users of the ProjectPlace connector should consider rebuilding their reports on this new, Planview maintained, certified connector.

You can find this connector in the Other section of the Get data dialog.

Shortcuts Business Insights connector

The Shortcuts Business Insights connector enables you to consume, read and analyze your data collected via your Shortcuts point of sale product of choice. Gaining access to this data will enable you to realize valuable business insights from your appointment, transactional, client, employee, product, and service data. These insights will allow you to better serve your customers and anticipate their needs, while growing your business to its full potential.

You can find this connector in the Other section of the Get data dialog.

Vessel Insight connector

Vessel Insight is a vessel to shore data infrastructure delivered as a service. The service enables shipowners, operators, and charterers to capture data from onboard systems such as propulsion, navigation, cargo, VDR as well alarm and engine management systems. Vessel Insight aggregates and contextualizes the data before transferring it to the cloud using the KONGSBERG Global Secure Network. The Vessel Insight Power BI connector makes it easy to integrate and combine vessel data with existing systems and streamline reporting and decision making.

You can find this connector in the Other section of the Get data dialog.

Zoho Creator connector

Zoho Creator is a low-code cloud software which lets you create custom applications for your business. Zoho Creator can collect data, automate business processes or workflows, analyze the data in reports, and collaborate with your application users. The Zoho Creator connector allows you to analyze data and share insights based off all data in Zoho Creator, aside from the pivot report.

You can find this connector in the Online services section of the Get data dialog.

 

Power BI may notable updates go like that! You can click here to download this month’s update. You can reach our other articles about Power BI here. Take care.

Good game well played.

Best Careers For Zodiac Signs and Recruitment

We see that each day a new approach emerges in human resources management. When it comes to choosing candidates there is no scientific approaches; intuition is the most important tool that the employers have. And a new approach is using zodiac signs in human resources management. In recent years, an insurance company in Salzburg, Austria advertised in the newspapers that sales and management department personnel of Capricorn, Taurus, Aquarius, Aries and Leo zodiac signs will be employed. In countries like the USA, Australia, Canada where asking personal questions while recruiting is forbidden zodiac signs are used to obtain information about characteristics of candidates. Nowadays in many countries human resources specialists don’t forget to check zodiac signs and it has become very common to work with astrology. Actually, there are companies that give this service. Jwalant Swaroop from Happy Ho stated: “We had clients who used astrology to choose senior candidates, including IT companies.” If this trend becomes a practice, candidates might start to mention their zodiac signs in their resumes soon. Don’t get surprised if you see zodiac signs in job advertisements.

And now we can talk about job-related features of zodiac signs and which professions are best for them 😊

Aquarius (January 22 – February 19)

Aquarius are known for being fond of their freedom. It is the cleverest of 12 signs. Its humanist nature sets Aquarius apart from the others. They act with logic. Aquarius who loves to renew itself is successful especially in professions in the technological area. Working home-office would be very convenient for them considering their need of movement and freedom. The Aquarius loves to explore innovative ideas and is very curious. It can be said that the Aquarius that is mostly found in non-conventional professions is the sign that is least suitable for the corporation life. Convenient areas for you: IT, Engineering, Computer Technician, Astrologist, electric electronic .

Pisces (February 20- March 20).

The most prominent feature of Pisces is being emotional and change. They are not that ambitious. They are very nice to others, suitable for teamwork and also have very strong intuition. They are not successful at jobs that require authority and harshness. They have the best imagination and can be successful at art. Intuition and help oriented jobs would be better for them. Areas for Pisces: Psychology, physiotherapy, nurse.

Aries ( March 21 – April 20) 

Aries is suitable for high-energy jobs. It is a full of life, active, competitive and ambitious sign that can’t tolerate losing. They are a leader from birth, they don’t like to work under orders. They are very suitable for being managers thanks to characteristics like deciding right away, organizing people and being punctual. Suitable areas for Aries: Marketing, Sports trainer, manager, soldier, entrepreneurship .

Taurus (April 21- May 21)

Taurus is calm, unaccommodating and cautious. The Taurus who don’t like to take risks or get out of their comfort zone are interested in safe and guaranteed jobs. It is one of the signs that are loyal to their jobs. Determined, patients and organized Taurus is one of the most well adjusted people in the workplace and make great teammates. They can work in any position from leader to follower. Also serious, patient, ambitious but intolerant, strict managers might turn out to be a Taurus. Suitable areas for Taurus: Banking, stock market, purchase and sale, real estate.

 Gemini (May 22- June 22)

Gemini are more prone to dynamic jobs. They don’t want to do boring and routine jobs and desk jobs are not the best for them. Jobs requiring trips are very suitable for the Gemini. They are really good at language learning. They are excellent candidates for key positions abroad or jobs that require communication and a social circle. Suitable areas for Gemini: journalism, advertisement, translation, social median expert.

 

Cancer (June 23- July 22)

The Cancer is very compassionate. They are one of the most humanist signs and love to take care of people. From the perspective of carrier, they are creative at solving problems and giving advises. Suitable areas for Cancer: Human resources, psychology, kindergarten teacher.

Leo  (July 23 – August 22) 

Leo loves to work at jobs that bring along a title and strength. They are not the best team players to be honest. Courage and domination is their most prominent features. They are always honest and right. Even though they are preferred by any profession because of their strong royalty, because of their bossy aura they have a hard time in positions apart from senior executors. The Leo prefers to  choose  respected jobs in private sector. Suitable areas for Leo: Management, organization management, CEO, director.

Virgo (August 23 – September 22)

Virgo pays attention to the smallest details and are perfectionists in the working life. They see the details that nobody else does. They like to analyze their work really well. They don’t work with assumptions, they act with logic. It is one of the most disciplined signs. Suitable areas for Virgo: Mathematics Engineer, IT, accounting, banking, architect.

 Libra (September 23- October 22)

Libra loves to bring people together. Giving attention to human relations and working with others make them happy. They achieve success in the service sector and human relations. And jobs concerning aesthetics are for them. Areas suitable for Libra: Travel agent, costumer representative, aesthetician, public relations.

Scorpio (October 23- November 21)

Scorpio has a very important place at work with its strong willpower, ability of moving on after the truth without giving up and with its deep-thinking character. They love to challenge and research. They are a bit of control freaks. The biggest disadvantage of Scorpio at work is  skepticism. They have a very hard time trusting. Especially jobs that require skepticism, detailed research are suitable for the Scorpio. Suitable areas for Scorpio: Manager, detective, scientist, archaeologist, crisis and finance management

Sagittarius ( November 22 – December 21)

Just like the Taurus, Sagittarius are one of the best team players. They are well adjusted. They get along well with their managers, they are extroverts. They can deal with stressful situations easily. The full-of-energy Sagittarius loves to learn and travel. Field jobs can satisfy the Sagittarius. They are very successful at sales thanks to their persuasive skills. Suitable areas for Sagittarius: Public relations, sales experts, marketing, import-export foreign trade expert.

Capricorn (December 22 – January 21)

Capricorn is the most workaholic of all 12 signs. They don’t run away from responsibilities, they are authoritative and disciplined. If they have a goal, they work ambitiously without paying attain to obstacles. They make amazing managers.   They were born to be a CEO. Doesn’t matter the sector, the Capricorn will be very successful as a manager with its strategy-producer and planner characteristics. Since they have the leadership qualification they are wanted  in organizations as administrators. Suitable areas for the Capricorn: CEO, Banking, Computer Engineer, any profession about IT.

We Welcomed the Webrazzi Team at our Office

We welcomed the Webrazzi team that visits important enterprises and technology centers in Turkey for the second time, this time at our new office. You can watch the program that we recorded in February.

Sputnik Radio “Corona Diaries”

Our COO KadirCan Toprakçı appeared as a guest on the “Corona Diaries” program presented by Serhat Aydın on Sputnik Radio. In this broadcast that we talked about our Digital workplace platform Velocity, we talked about our global success and solutions that we offer.

Microsoft Office 365 May Updates

A New Meeting Experience with Microsoft Teams

Soon Microsoft Teams meeting will be opened in a separate window than the main Teams screen! Also the control bar on which turn off camera/mute, raise hand, chat, leave meeting options are found will be located on top of the screen. This way the meeting image on the background will not be blocked. The place of control bar was one one the features that got a lot of negative feedback.

And let’s not forget to mention that in the new meeting experience there are 9 3×3 screens instead of 2×2, with the raise hand feature you can send a visual signal that you have something to say and that we can upload our own backgrounds in addition to the recommended backgrounds.

Adding Online Meeting Option to All Meetings

Another feature coming to our online meetings is having the option of adding “Online” option to all meetings as default. When this feature is activated Outlook Web, Outlook Mobile (iOS and Android) Online meeting option will be added for all Teams and Skype for Business meetings. This feature is not compatible with 3rd Party online meeting applications. If users don’t activate this option, they will add the Online option manually each time they setup a meeting.

Chat and Meeting Between Teams and Skype Consumer

Skype Consumer and Teams working together is one of the most requested features. Finally users in the organization and Skype users can have a meeting and chat. This feature has been on External Access page of Teams Admin Center, now it will be available for active use.

With the “Pre-publish” option located on the right part of the SharePoint screen it will be possible for the page editors to analyze how page will look after being published and edit if necessary with the preview option before publishing.

 

Inviting Office 365 Group of Distribution List to Teams Meeting

It will be possible to invite everyone in a Teams team or Distribution List while setting up a new Teams meeting. This way groups/lists will be added as an individual or invitation will be sent to everyone in the group/ list. without setting up a meeting inside the channel.

Outlook Web – “Send later”

Soon it will be possible to send e-mails written on Outlook Web later with the “Send Later” option. This feature will come among the Outlook rules and it will be possible to apply this feature in mass.

Microsoft Stream Screen Recording

Finally screen recording is going to be available for Stream! Now it is possible to recorde a window or the whole screen and making it professional by adding microphone, sound and webcam options. You don’t need to download any applications, you can you use this feature with the latest versions of Edge or Chrome browsers.

Office.com Main Page Layout is Changing

Now the layout of Office.com portal starts with the option to create a new document with “Start New”, and continues with a horizontal list of our most important applications. New portal is going to be symbolically moved to left vertically.

 

Background Policies in Teams Meetings

Now there is an update concerning Teams Admins. Soon we will be able to control new features like blurring or changing background by assigning user based policies. For example we can allow some users to add custom pictures and some to just blur. Policies will be under 4 main titles:

  • No filters are available.
  • Only background blur is available.
  • Background blur and default images will be available.
  • Everything is active: Background blur, adding custom images in addition to default images.

SharePoint Spaces Preview

SharePoint Spaces is a web-based platform, which lets you create structures, themes and backgrounds to which they can add web parts and that contain 3D objects, 360° images and videos, 2D images and texts. 3D results can be watched in the web browser or mixed-reality headset.

 

Things to Pay Attention to while Migrating a .NET Framework Project to .NET Core

At PEAKUP there is a new “Data” project that we have developed a long time ago in order to provide some data that our own products need from one center instead of keeping it app based. First of all, I want to talk about what the application does and what it contains. We started to develop the project with .NET Core when it first came out and then migrated to .Net Framework to wait a bit more till .NET Core becomes a bit more stable. The data base was designed completely with EntityFramework Code First. We use Azure SQL Server as database. This application alongside the geographical information like continent, country, city also has information that is needed in pretty much any application like 2020/2020 Public Holidays, current weather condition and exchange rates. There are also 2 more Azure Job Projects that connects to more sources and registers data for weather forecast and exchange rates and registers them to both the database and Cache in order to give faster outputs with Redis alongside the web app that we use for the presentation of data in the server.  

Why are We Migrating to .Net Core? 

 First of all, when we take a look at Microsoft’s development efforts for .Net Core and what is going on, it is not hard to foresee that in the long term the developments for .Net Framework will stop after some time of they will be restricted. It is obvious that some stuff I will talk about are possible with .Net Framework as well, but they are not as good as .Net Core for sure and that some problems come up and cause extra time-loss.

Seeing the libraries for features like Image Compression, Video Compression that we want to add to the Project soon are only developed by .Net Core is very important when it comes to cutting the effort for the long-term developments in half.

A big increase in the weather forecast and exchange rates data is observed while the number of users in other PEAKUP products who send request to the application increase. Taking precautions for the upcoming problems of the increase in Response time as the number of requests to the app and data size increase, and web app we use and SQL data base becoming a problem in terms of cost and performance are among the most important reasons.

For now we keep the project in two different Git Branches. We do the developments on Dev, after seeing that everything is okay we merge it to Master and run all the Deployment activities manually during this process. Even though it is not a project that we open and work on frequently, this process being out of manually deployed situation with Azure DevOps and the feature of automatically deploying and running Migrations on database on its own is a development we desire. Doing this more efficiently and faster with .NET Core is more flexible because package management in the project is designed in an easier way.

We used to switch between Azure Service Plans to scale unusual load the customers who changed to apps as SaaS by PEAKUP got when they completed the process once and announced the products to their users. This causes some restrictions on the side of  Azure Web Application in terms of costs and scaling the application.  The app moving to Containers completely thus Scaling Down itself and run limitless Containers and responding all the request with the same speed or even faster in case of need with Azure DevOps was one of the features we desired. After the tests I did after I migrated the project, I saw that it was too early for the steps concerning Docker and Kubernetes and decided to continue with the web application.

Problems I came across and their Solutions 

  • Change in Routing

I started to foresee how achy the migration is going to be when I came across this problem that I spent almost half a day on. There were two GET methods we used in the Interface design in the project and one of them routed all the records and the other routed the data as to Id parameter it got. I researched and found out that it is not allowed yet to prevent faulty designs concerning Routing on .Net Core. For this I decided to continue with a method that acts differently on each occasion by nulling the Id parameter in the method.

  • Different Names in Entity Framework Core 

I used all the models we used while developing the project while switching to .NET Core. I was sure that Schema that was going to be on database thanks to Auto Migration was going to be the same but I saw that while domain names where relationships are established on .NET Framework didn’t go through any changes between the areas used for relationships, on .NET Core underscore was added. For this to set up Schema as it is and to migrate the data on Production directly, I utilized the [ForeignKey(“X_Id”)]  attribution to make the data on the column suitable with the old standards.

  • Database Migration

I imported a copy of around 12GB data to a server on Azure without losing any data on the database. From there I took a data around 12GB that I zipped and downloaded to my computer to my device as a 900MB text and started to try scenarios concerning data migration. Weather, Forecast and Currency tables were the main reason of size being that big. For this I decided to move on by migrating these three tables one by one. I can say that between the scenarios I tried, I did benchmarking in SQL, so to speak.

Even though I ran the file I imported completely on a database and then provided data entry, these actions took too long and after a while if there was a mistake all the time I spent would turn to dust. Therefore I chose the Import Data option that came as default in SQL Management Studio to migrate each line one by one and to see the consistency between the Schemas on two different databases. In this step I saw that Entity Framework created the the data type difference of datetime on .NET Framework and datetime2 on .NET Core.

I went back to the project and added the [Column(TypeName = “datetime”)] attribute in the beginning of the Datetime fields and made sure that it stayed that way for the data migration on Schema and imported it successfully to my device in 15 minutes.

To run an EF Core database on Production I deployed both the data base and the application by opening the Web Application. I decided to go on with the Linux Web Application I used for .NET Core and then had some problems. I talked about them in the upcoming steps.

  • Library Change on the Cache Layer

We used to use the ServiceStack.Redis library that had a better performance and API design and that offered a cache memory solution with a higher performance with its specially developed JSON library. But since the Nuget library on which we did this development hasn’t been updated for a long time thus we stayed away from this benefit and we didn’t see its performance concerning Connection Pooling I changed to Stack.Exchange.Redis Library developed by StackOverFlow.

  • Critical Lacks in Text. Json

I can say that Microsoft has been obsessed with developing System.Text and all libraries under it for  performance and JSON actions of .NET Core for a long time. I have been following that there is an increase of performance in almost all Framework versions in a lot of projects that use System.Text Namespace when benchmarking tests are done. I thought and guessed that a library coming from Built would be better in JSON’s routing in API to get rid of Newon.Json’s and ServiceStack.Redis’ JSON library  data reading-writing to Cache. But than a huge disappointment waved at me! Cause I saw in the Microsoft Document published about migrating from Newton.Json that many features like PreserveReferencesHandling, ReferenceLoopHandling haven’t been developed.

  • Features in Linux Web Application that haven’t been completed on Azure

First I ran the application in a standard way that I can manually test and then run performance test without waiting for a Pipeline and to continue after Staging. I started the action by publishing and came across a 1-hour disruption on Azure by chance and thought that there was something wrong with the application. After losing two hours I found out that there was an incident on Microsoft and some issue might occur on the European continent that we work on. At that point I started to work on the next steps on the application. And I realized that the disruption was a blessing!

Some of the data we import concerning exchange rates and forecast flow instantly and some of them flow hourly. We dealt with them without leaving the job as Azure Job before anyways. I couldn’t find the Web Job tab inside the Web Application to observe some problems about it staying the same way and what will happen! First I thought it might have to do with the Tier of the application so I moved to an upper Tier and Web Job didn’t come back.  Then when I did some research I found out that Linux type Azure Web Applications lacked a lot of things. Without waiting for the disruption to be over I deleted the application and continued by opening a new Windows type web application.

The reason I made that decision had to do with the structure continuing through Kubernetes and Container depending on the success of Load tests.

  • Load Testing  

There is a paid and an unpaid tool developed by the engineering team of SendLoop know by everyone as an e-mail marketing company. I always wait for the first test to go through here with this tool that you can reach on https://loader.io/ and then do the load tests with EU project of Apache. The first test with this tool that goes up to 10.000 requests was pretty successful. A serious decrease was seen in response time but after a while the application would start to slow down.

I realized that there was an unreasonable expansion in Memory in Web Application and that after a point there was no space even a space of 1 MB. When I analyzed the requests I saw that the method I used was going on with AddAndWrite scenario instead of OverWrite on the given Key of data! I solved this problem right away and continued the tests after upgrading the packages.

After I saw that requests passed successfully on SendGrid I started to do tests with the EU Tool. For this I used a server that had a very good internet connection. Now everything is ready and I can move on to the last step on DevOps.

  • Changes in DevOps Pipeline Setup 

After I turned the project into a condition that received requests, I started to separate it into three Stages: Production that I talked about in the beginning of the article, Beta that works with a live environment and code development and DEV. First I completed the migration in a way that Master, i.e. Production would follow the sequence.

And I came across an interface change Azure did on DevOps Pipeline. I found out that the infrastructure of the library i.e. changes done concerning ConnectionString, special keys etc. are added as a Step while  migrating Artifact output to the Release step with a Versioning system now.

Teams and Cloud Storage – A Deep Insight

[vc_row][vc_column][mk_fancy_title size=”20″ font_family=”none”]In the last week of our event we went to the beginning and thought about what more we can do on Teams while working from home and talked about the new features, Pop-out Chat being in the first place. Easy but important features like how we can filter our unread messages and notifications, how we can arrange our left navigation panel were among our event subjects. We also talked about the differences between opening Office apps on Teams/Online and opening it on desktop. We took a look at options like pinning for rapid access, pinning as a tab, installing the files we choose on the Files. 

We analyzed the notification settings on Teams Mobile app and talked about “receive mobile notification when Desktop app is not active” and pinning Chat/Channels to the frequently used. In the second part of our event we went into more details about accessing Version History. We talked about the storage space and technical differences between Chat and Channels. Saving an online only file from 1st and 2nd phase trash bins in what time and how when we delete it was one of our important topics.


Also, how to share a file without sending to Teams, having the files as only accessible when they are shared, limiting authority to edit and download were features that enable us to work in a safer environment. While we analyzed sending the files added to SharePoint Online to approval with “Request Sign-off” which was the last subject of our event, we showed how to access PowerAutomate templates in SharePoint.  [/mk_fancy_title][vc_video link=”https://youtu.be/hHUyTt-5zCo”][/vc_column][/vc_row]

The Most Basic DAX Functions of Power BI

Hello dear reader! In this article we will be talking about the most basic DAX functions of Power BI. We use these functions a lot in our daily lives. And this shows us that we will be using these while preparing reports.

 

Keep calm and think simple 😃 Yeap, the functions I will talk about go like this:

  • Count (COUNT)
  • Sum (SUM)
  • Calculate the average (AVERAGE)
  • Find the maximum value (MAX)
  • Find the minimum value (MIN)

 

All these functions have a very simple structure. We usually use the functions above in measures. The results of measures give a a single scalar value. We are looking for the answers of questions below as a single scalar value.

I got the exemplary data set for application of these functions from kaggle.com. You can reach example datasets here. This data set contains information about video games like name, rank, platform, year, genre, publisher, global sales . We will be getting answers of some questions we ask to the data set with the functions above.

Let’s transfer this data set to Power BI first. For this choose Text/CSV from Get Data options on the Home tab and lead to this data set. When you click OK to get this .csv format file it will recognize the bracket between texts and display the version automatically divided into columns on the Navigation window and we will only need to click Load.

In this stage we will try to get the answer of the questions below from this data set.

1-How many games are there?

Lets’s satisfy our curiosity about this first. We will count how many games there are by using the COUNT function from the basic DAX functions. We can use any column for this action. We usually choose the columns that we know will never be empty for counting. We write the related table and column name inside the COUNT function and execute this action. You can find the related syntax below: 

Game Count= COUNT(vgsales[Name])

By typing this function we find out that we are talking about 16.598 games here.

2-What is the sum of values on the Global_sales column?

When we talk about sum of values on a column another basic DAX function comes into play. We will obtain the sum of values on the GlobalSales column by using the SUM function. We have to choose a column with numeric values to use the function. The column we want the sum of contains numeric value of Decimal Number data type. We do the action by writing the related table and column name into the SUM function. You can find the related syntax below: 

GlobalSales Sum= SUM(vgsales[Global_Sales])

We obtain the sum of values on the GlobalSales column as 8920.44 with this function.

3- What is the average of values on the Global_Sales column?

Let’s find the average for the same column. If we are talking about the average of values on a column, the function we will use is AVERAGE. To use AVERAGE function as well we have to choose a column that contains numeric data type just like in the SUM function. We can obtain the result we want by writing table and column name in AVERAGE function just like the two functions above. You can find the related syntax below: 

GlobalSales Average= AVERAGE(vgsales[Global_Sales])

AVERAGE function gives as the answer as the value of 0.54. The average sale price of the games in this data set is 0.54.

4-What is the maximum of the values on the NA_Sales column?

This time we have another curiosity on another column. What is the maximum sales value on the NA_Sales column? The answer of this question can be provided by the MAX function only. Of course for this function too the related column has to contain numeric value. But this function gives us two syntax options: we can find the maximum value in a column, or can tell which one is bigger of two scalar values. We will request the maximum value in the whole column. The general use of MAX function is like that. You can find the related syntax below: 

Maximum NA_Sales = MAX(vgsales[NA_Sales])

According to the information we obtained with this function, the maximum value on the NA_Sales column is 41.49.

5-What is the minimum of the values on the NA_Sales Column?

This is the last question we will be asking: What is the minimum sales value on the NA_Sales column? We will use the MIN function to get the answer of this question. While it has been built to bring out the minimum value, the syntax is completely same with the MAX function. The general use is to find the minimum value on a column. You can find the related syntax below:

Minimum NA_Sales = MIN(vgsales[NA_Sales])

According to the information we obtained with this function the minimum value on the NA_Sales column is 0.

With this last question we answered all the questions above by using the most basic DAX functions.

 

DAX fonksiyon sonuçları

If you please, you can download the .pbix file in which all these actions are done here. Until next time, bye!

Good game well played.