A-10 Calculating Average/Usage of Earlier function in PowerBI.Problem Statement:Jun 3, 2021Jun 3, 2021
A-9 Create a new measure (Not calculated) and use DAX to calculate RANK.Solution:May 30, 2021May 30, 2021
A-8 Create 3 measures (YTD/Moving Average/ previous Quarter Percentage) using the screen shot belowSolution:May 29, 2021May 29, 2021
A-6 CREATING FLAG COLUMN BASED ON LOGIC / PLOTTING GRAPH USING NEW VARIABLE/ USING RELATED(LOOKUP)…DataSetMay 2, 2021May 2, 2021
4/5 — Split columns and modify dates in PowerBI — Visuals providing various data slices.In the below example, we will be splitting the “Written by” column into two and replace the nulls by blanks We also will format the dates…Mar 26, 2021Mar 26, 2021
3-Sorting Richest PeopleImport the list of rich people. Convert the column “Net worth” into integer by rounding the values and removing “billion” and “$”. Then…Mar 23, 2021Mar 23, 2021
Power of Power BI- KPIsPower BI can be used to create multiple Key performance indicators in your business. This is used to evaluate the impacts of various…Mar 12, 2021Mar 12, 2021