AMA-10 Calculating Average/Usage of Earlier function in PowerBI.Problem Statement:Jun 3, 2021Jun 3, 2021
AMA-9 Create a new measure (Not calculated) and use DAX to calculate RANK.Solution:May 30, 2021May 30, 2021
AMA-8 Create 3 measures (YTD/Moving Average/ previous Quarter Percentage) using the screen shot belowSolution:May 29, 2021May 29, 2021
AMA-6 CREATING FLAG COLUMN BASED ON LOGIC / PLOTTING GRAPH USING NEW VARIABLE/ USING RELATED(LOOKUP)…DataSetMay 2, 2021May 2, 2021
AM4/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
AM3-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
AMPower 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
