Average, Max and Min are most commonly used in Excel and it’s quite handy to use this function combined with other calculations. Let’s learn different types of Max, Min & Average DAX functions. MAX() MAXA() MAXX() MIN() MINA() MINX() AVERAGE() AVERAGEA() AVERAGEX() The concept is same for all. MAXX() , MINX() & AVERAGEX() will beContinue reading “All types of Average, Max & Min (Statistical DAX)”
Author Archives: Lashmi Bai Ravindrapandian
How I ended the Year 2021
It was in mid-2021, and I decided to take a professional or career break, as I was not getting right opportunities. Thanks to Covid, many people and corporates are seeing the positive side of career gaps in one’s life. A career gap is a period of time out from employment. It is commonly used for people toContinue reading “How I ended the Year 2021”
All about Power BI Service (PL-300)
Key pointers from the MS Learning path for PL-300 Manage workspaces and datasets in Power BI 1. Workspaces have the highest level of security maintained by controlling who can access semantic models, reports, and dashboards 2. By default, when creating a workspace, you provide the below basic details 1) Workspace Name 2) Workspace description 3)Continue reading “All about Power BI Service (PL-300)”
How to deal with 21 Office Situations
Recently I got to read a book titled “21 Office Situations and How to deal with them” written by Anil Karamchandani. Thought to write a synopsis of the book, so it will be a good recap. As there is no one way to solve the problems, few of the insights were good to know. ThisContinue reading “How to deal with 21 Office Situations”
Growth Hack – Digital Marketing
Out of self-interest, recently I took a one year paid subscription for a Digital Marketing Newsletter from one of the renowned Growth Hacker. Here’s the mind-blowing Growth Hack tips from his daily subscription. I kept on collating the key hacks during my leisure time so that it will be useful for everyone including me 🙂Continue reading “Growth Hack – Digital Marketing”
All about Build Power BI visuals and Reports (PL-300)
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)”
Jira structures Formulas
Hi Readers, This is continuation of post on Jira Structures. Check out the post here to know the basics of Jira Structures. Coming up more formulas for ready reference. Formulas to use in Structures: IF duedate < now() : DAYS_BETWEEN (duedate, NOW()) CONCAT “days late” Roll up earliest start date to parent: IF (COUNT #CHILDREN{0},Continue reading “Jira structures Formulas”
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)”
All about PMO Set Up
Here’s I’m summarizing the learnings of the PMO set up process from various sources. As PMOs come in varying shapes, sizes, and personalities, it was very interesting to learn from his experience. Do you know who is he? Yes, I’m talking about the teachings of Hussain Bandukwala, Founder and Chief PMO Coach at Parwaaz Consulting. RecentlyContinue reading “All about PMO Set Up”
LR Virtual Classroom 