Key pointers from the MS Learning path for PL-300 Build Power BI visuals and reports 1. Goals while desiging the reports 2. An analyst is a person who provides guidance to the organization. Analysts can be responsible for a range of tasks, often with goals of determining the effectiveness of business strategies, developing or improving processes, orContinue reading “All about Build Power BI visuals and Reports (PL-300)”
Category Archives: Power BI
All about Power – BI Mobile Apps (PL-300)
Key pointers from the MS Learning path for PL-300 Power – BI Mobile Apps 1. Microsoft Power BI offers a set of mobile apps for iOS, Android, and Windows devices. These mobile apps let you connect to and interact with your cloud and on-premises data when you’re on the go, anytime, anywhere. 2. All theContinue reading “All about Power – BI Mobile Apps (PL-300)”
A-Z COUNT DAX Functions (Statistical)
In this post, we are going to learn all the COUNT related DAX fuctions. 1 – COUNT() The COUNT function counts the number of cells in a column that contain numbers. Syntax: COUNT() For example, The following example shows how to count the number of values in the column, ShipDate. COUNT EX = COUNT(InvoiceDetails[InvoiceNumber]) ThisContinue reading “A-Z COUNT DAX Functions (Statistical)”
Calculated Column vs Calculated Measure
Calculated Column vs Calculated Measure is the most commonly used term in Power BI. Both these features have many roles to play and it is important to understand the difference. You may ask why? Yes, using it appropriately will save you a huge amount of space in your report. If you understand that the mainContinue reading “Calculated Column vs Calculated Measure”
Helpful DAX resource
Do you know the common DAX functions can be easily learned in Power BI? DAX is simple to learn at a basic level, but advanced DAX skills require a deep understanding of storage & calculation, data engines, table & filter functions, relationships, iterators, etc., hence we need helpful resources. Let’s see the four helpful DAXContinue reading “Helpful DAX resource”
Common Date & Time Functions (DAX)
We saw the basic level Date and Time DAX function here. Now, let’s deep dive into some more commonly used Date and Time functions. EDATE Function EOMONTH Function TIMEVALUE Function ENDOFMONTH Function ENDOFQUARTER Function ENDOFYEAR Function FIRSTDATE Function FIRSTNONBLANK Function LASTDATE Function LASTNONBLANK Function EDATE Function: This function returns the date that is the indicatedContinue reading “Common Date & Time Functions (DAX)”
DATEADD vs DATEDIFF vs DATEBETWEEN vs DATESINPERIOD
In this post, we are going to learn about the DATEADD, DATEDIFF, DATEBETWEEN, and DATESINPERIOD functions. These functions are very useful when dealing with dates. DATEADD Function (DAX) Definition: Returns a table that contains a column of dates that has been shifted or moved by no of intervals mentioned in the field. The result isContinue reading “DATEADD vs DATEDIFF vs DATEBETWEEN vs DATESINPERIOD”
How to move measure from one table to another in Power BI
Recently, I struggled to move the measures which I have created under wrong table in Power BI. I found an easy solution and here I’m with the post documenting my learnings. The ability to move measures from one table to another table exists in Power BI. The process is simple and much better than re-creatingContinue reading “How to move measure from one table to another in Power BI”
AllSelected & AllNoblankRow (DAX)
The filtering functions let you manipulate data context to create dynamic calculations. Today, lets learn about the new filter functions named AllSelected() and AllNoblankrow(). The filter functions in DAX are some of the most complex and powerful, also differ greatly from Excel functions. Check out the post for most commonly used functions All() & AllExcept().Continue reading “AllSelected & AllNoblankRow (DAX)”
All vs Allexcept
All and Allexcept are useful filter related DAX functions which will help in data analysis many ways. The ALL () Function returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied whereas ALLEXCEPT() ignores all the filters applied except the one called under parameters.Continue reading “All vs Allexcept”
LR Virtual Classroom 