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”
Author Archives: Lashmi Bai Ravindrapandian
To be a successfull PMO Leader
Recently I attended a webinar conducted by PMI, wherein they highlighted the key success factors to be a PMO Leader. It was a very good session and thought to share the key learnings in this post. It’s easy to adapt when you write something rather than just hear/read. I’m sure this post will help anyoneContinue reading “To be a successfull PMO Leader”
All About SharePoint Online
The UI of the Sharepoint online was so easy to make navigation and achieving simple tasks easy. It is easy on the eyes. Out of curiosity, summarizing the learnings about the key features here to enable your checklist as well. Hope you find it useful. Office 365 SharePoint Trial Version: Frist of all, lets knowContinue reading “All About SharePoint Online”
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)”
All about Power Pivot
Excel’s Power Pivot is a standard Excel desktop feature. Power Pivot along with Power Query with Pivot table and Pivot Chart is the wonderful combination in the Excel for data analysis of huge data sets. To enable Power Pivot menu, simply right click on the toolbar and then select customize this ribbon. Over to the right here make sureContinue reading “All about Power Pivot”
Microsoft Tools for Project Management
Microsoft is one of the organization, I truly admire for their products specifically for Project Management. This is not an affiliate post, just an opinion about the variety of products they have and how quickly they adopted to build multiple products for the organizations to scale their business. Right from MS Office suite to latestContinue reading “Microsoft Tools for Project Management”
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”
S-Curve in Project Management
Recently came across the keyword S-curve. Though familiar, out of relearning the concept, sharing the learnings about the S-curve is the most important representation in Project Management. It is commonly used to track the progress in terms of budget and check if it stays on schedule. The S-curve is a graphical representation tool that canContinue reading “S-Curve in Project Management”
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”
LR Virtual Classroom 