Posts

How to write DAX formula in power BI?

Image
 How to write DAX formula in Power BI? Step1: Select the Get data from other sources and click on it. Step 2: Click on the use sample data and click on it. Step3: Select and click on the load sample data. Step 4: Select and Click on the navigator financials.  Step5: Select and click on the financials and load the data. Step 6: Select and click on the Data tab. Navigate to the home tab, select and click on the new measure. Step 7:  Click on the cross icon and deselect all. Navigate to the home and select and click on the quick measure tab. Step 8: From the Select a calculation to create a measure option,select as average per category. From the base value option, select profit and mark as ticked from financial tab & drag to base value From the category option,select product and marked as tick from product.Click on the Add button. Formual shown will be appeared as below: Sum of Profit average per Product 2 = AVERAGEX (     KEEPFILTERS ( VALUES ( 'financials' ...

YOUTUBE NEW UPDATE 2025 DIGITAL SCEURITY CONTENT POLICY

 YOUTUBE NEW UPDATE 2025 DIGITAL SCEURITY CONTENT POLICY INSTRUCTIONAL THEFT:  It is the type of content which is having intention to steal physical goods or get something free which is paid to use You tube harmful or dangerous content policy which prohibits the instructional theft. HACKING: If you try to demonstrate how to use computers or information technology with the PHISING: CRYPTOPHISING:  intention of stealing credentials, compromise the personal data of others or cause serial harm to others   BYPASSING PAYMENTS FOR DIGITAL CONTENT OR SERVICES: Content which shows viewers: How to get unauthorized access to content, software or services which usually requires payment.

Protected content can't be viewed on this device.

Image
 How to resolve and fix this issue on window 11 operating system? Protected Device cannot be view on this device.  Step 1: Uninstall anti-virus software to fix this issue. Control Panel\System and Security\Windows Defender Firewall\Customize Settings   Step 2: Open the control panel -> click on the network sharing center -> select and click the media streaming option->show device on all the network->click OK   Step 3: Go to start menu->type firewall and network protection->open-> turn the domain network,public network and private network off.   Step 4:Go to start menu->type Device Manager->open->select the display adapter->select option->update driver.   Step 5: Go to start menu-> type Network status ->Control Panel\Network and Internet\Network and Sharing Center->Change adapter settings->turn off or disable wifi->Enable wifi  Step 6:Go to start menu-->type connect app...

Introduction to Linux Tutorial in English

Image
 Introduction: It is an operating system which is much like Microsoft window and apple Macintosh. It is open source and freely available without any cost. It is Unix like computer operating system which are assembled at free cost and under open-source software development & distribution. It shares the kernel and has gnu utilities. It comes in different variations to serve different purposes of end users. Debian: It is well known for its reliability and extensive package repository which may be used for both production and development environments. Red hat: It is used in server environments. Linux mint: It is suitable for beginners who want to compare with Microsoft os.Fedora: It is popular choice for the developers and perfect platform for software testing and development. Gentoo Linux: It is used by advanced users. CentOS: It is used in server environments. Ubuntu: It is used by the beginners. OpenSUSE: It is preferred by system administrators.Archlinux: It is used by advanced...

PYTHON TUTORIAL INTRODUCTION

Image
 Introduction: It is popular programming language which is used on the server to create the web applications. It was created by Guido Van Rossum and was released in the year 1991. It is used for web development i.e. server side. It is used for software development. It is used for mathematics and system scripting. What is the use? It can be used on the server for creating the web applications. Frameworks like Django and flask are used for web development. It can be used with the software for creating workflows. It can connect to the database systems for reading and modifying the files. It is used for handling the big and complex data and perform the complex mathematics operations. It is used for rapid prototyping of the production software development as ready. It is used in desktop applications with GUI frameworks like Tkinter and PyQt. It is used in data science for doing data analysis and libraries like pandas, NumPy and Matplotlib are used. It is used in machine learning and AI ...

Top 100 SQL Realtime scenarios-based interview questions.

Image
 Q1) Write an query to print the salaries of employees above 3000 as high salary or low salary. Ans select ename,sal,case when sal>3000 THEN 'High Salary' ELSE 'Low Salary' END AS salary_category from emp; Q2) Write a query to retreive the last five records from the employee table based on the empno. Ans    select * from emp order by empno desc               fetch first 5 rows only; select * from ( select * from emp order by empno desc ) where rownum<=5; Note: In oracle, limit clause is not used. You can use FETCH first n rows or ROWNUM to achieve the result. Q3) Write a query to fetch employees who earn more than the average salary. Ans select * from emp where sal>(select avg(sal) from emp); Q4) How do you find the second highest salary from the employee table. Ans select max(sal) from emp where sal<(select max(sal) from emp); Q5) How to find all the duplicate records in the employee table taking all the colum...